[Home] [Help]
148: (ci_bepid iby_bepinfo.bepid%TYPE)
149: IS
150: SELECT sys_cc_profile_code,online_auth_trans_prtcl_code,
151: settlement_trans_prtcl_code,query_trans_prtcl_code
152: FROM iby_fndcpt_sys_cc_pf_b profs
153: WHERE profs.payment_system_id = ci_bepid
154: AND NVL(inactive_date,SYSDATE+30)>SYSDATE;
155:
156: CURSOR c_sys_eft_profile