APPS.AS_ATA_NEW_PUB dependencies on JTF_TAE_1001_LEAD_NM_TRANS

Line 593: AND EXISTS (SELECT 'X' FROM JTF_TAE_1001_LEAD_NM_TRANS TRANS

589: SELECT distinct sales_lead_id
590: FROM AS_CHANGED_ACCOUNTS_ALL CHNG
591: WHERE lead_id IS NULL
592: AND sales_lead_id IS NOT NULL
593: AND EXISTS (SELECT 'X' FROM JTF_TAE_1001_LEAD_NM_TRANS TRANS
594: WHERE TRANS.TRANS_OBJECT_ID = CHNG.SALES_LEAD_ID);
595:
596: CURSOR del_oppty_changed IS
597: SELECT distinct lead_id