APPS.IGS_AD_IMP_001 dependencies on IGS_AD_APPHIST_INT

Line 232: OR EXISTS (SELECT 1 FROM igs_ad_apphist_int WHERE status <> '1' AND interface_appl_id = api.interface_appl_id)

228: OR EXISTS (SELECT 1 FROM igs_ad_splint_int WHERE status <> '1' AND interface_appl_id = api.interface_appl_id)
229: OR EXISTS (SELECT 1 FROM igs_ad_spltal_int WHERE status <> '1' AND interface_appl_id = api.interface_appl_id)
230: OR EXISTS (SELECT 1 FROM igs_ad_perstmt_int WHERE status <> '1' AND interface_appl_id = api.interface_appl_id)
231: OR EXISTS (SELECT 1 FROM igs_ad_fee_int WHERE status <> '1' AND interface_appl_id = api.interface_appl_id)
232: OR EXISTS (SELECT 1 FROM igs_ad_apphist_int WHERE status <> '1' AND interface_appl_id = api.interface_appl_id)
233: );
234: COMMIT;
235:
236: -- Based upon transcript term child

Line 495: igs_ad_apphist_int applhist

491: FROM DUAL
492: WHERE EXISTS (SELECT 1
493: FROM igs_ad_interface int,
494: igs_ad_apl_int aplint,
495: igs_ad_apphist_int applhist
496: WHERE int.interface_id = aplint.interface_id
497: AND aplint.interface_appl_id = applhist.interface_appl_id
498: AND int.source_type_id = p_source_type_id
499: AND int.batch_id = p_batch_id