1) SQL: - %Select
(EMPLID) Select EMPLID from PS_AERUNCONTROL where PROCESS_INSTANCE =
%PROCESS_INSTANCE and ORPID = %oprid
2) People code: - &SQL = “Select EMPLID from
PS_AERUNCONTROL Where PROCESS_INSTACNE =” | PS_TEST_AET.PROCESS_INSTANCE | “and
OPRID =” | %oprid.
%PROCESS_INSTANCE or %Bind (PROCESS_INSTANCE) can be used.
%PROCESS_INSTANCE is more efficient and faster