APPS.IGS_AD_IMP_013 dependencies on IGS_AD_TXCPT_INT

Line 1738: AND EXISTS (SELECT 1 FROM igs_ad_txcpt_int

1734: TO_DATE('01-01-0001','DD-MM-YYYY'))) =
1735: TRUNC(NVL(a.end_date,
1736: TO_DATE('01-01-0001','DD-MM-YYYY')))
1737: )
1738: AND EXISTS (SELECT 1 FROM igs_ad_txcpt_int
1739: WHERE interface_acadhis_id = a.interface_acadhis_id
1740: AND status = '2');
1741: COMMIT;
1742: