APPS.IGS_AD_IMP_004 dependencies on IGS_AD_APPHIST_INT

Line 1720: AND ( EXISTS (SELECT 1 FROM igs_ad_apphist_int WHERE person_id = api.person_id

1716: ,error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E677', 8405)
1717: WHERE interface_run_id = p_interface_run_id
1718: AND status = '2'
1719: AND update_adm_appl_number IS NOT NULL
1720: AND ( EXISTS (SELECT 1 FROM igs_ad_apphist_int WHERE person_id = api.person_id
1721: AND admission_appl_number = api.update_adm_appl_number )
1722: OR EXISTS (SELECT 1 FROM igs_ad_insthist_int WHERE person_id = api.person_id
1723: AND admission_appl_number = api.update_adm_appl_number )
1724: );