APPS.AS_ATA_NEW_PUB dependencies on JTF_TAE_1001_OPPOR_NM_TRANS

Line 601: AND EXISTS (SELECT 'X' FROM JTF_TAE_1001_OPPOR_NM_TRANS TRANS

597: SELECT distinct lead_id
598: FROM AS_CHANGED_ACCOUNTS_ALL CHNG
599: WHERE lead_id IS NOT NULL
600: AND sales_lead_id IS NULL
601: AND EXISTS (SELECT 'X' FROM JTF_TAE_1001_OPPOR_NM_TRANS TRANS
602: WHERE TRANS.TRANS_OBJECT_ID = CHNG.LEAD_ID);
603:
604: CURSOR del_proposal_changed IS
605: SELECT distinct proposal_id