APPS.IGS_FI_CRDAPI_UTIL dependencies on IGS_AD_PS_APPL_INST

Line 1370: FROM igs_ad_ps_appl_inst apl_in,

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,
1371: igs_ad_ofrdfrmt_stat df,
1372: igs_ad_ofr_resp_stat off
1373: WHERE apl_in.person_id = appl.person_id
1374: AND apl_in.admission_appl_number = appl.admission_appl_number