[Home] [Help]
1362: CURSOR c_source_tran_ref (cp_party_id IN NUMBER,
1363: cp_appl_id IN NUMBER
1364: )IS
1365: SELECT 'x'
1366: FROM igs_ad_appl appl
1367: WHERE appl.person_id = cp_party_id
1368: AND appl.application_id = cp_appl_id
1369: AND EXISTS ( SELECT 'X'
1370: FROM igs_ad_ps_appl_inst apl_in,