Need a help in array code
Using Application Package we are getting the user ID to whom the approval should trigger. Below is the piece of code.
method GetUsers
Local string &SQLText, &SQLText2, &SQLText3, &requestorid, &supervisor;
Local string &bu, &vchrID;
Local string &OPRID, &seq;
&SQLText = "SELECT GROSS_AMT FROM PS_PR_REQUEST WHERE REQUEST_ID = :1";
&SQLText2 = "SELECT REQUESTOR_ID,OPRID FROM PS_N_PR_REQ_TBL WHERE REQUEST_ID =:1";
&SQLText3 = "select oprid, seq from(SELECT A.OPRID,rownum as Seq FROM PS_N_PR_APPR_LVL_V A, sysadm.PS_N_APPRVL_USERS B WHERE a.oprid = b.oprid AND a.N_APPRVL_LVL >= :1 START WITH A.OPRID=:2 CONNECT BY NOCYCLE PRIOR B.OPRID_TO_RPT=A.OPRID) X where x.oprid <> :3 order by seq ";