APPS.AS_ATA_NEW_PUB dependencies on JTF_TAE_1001_ACCOUNT_NM_TRANS
Line 585: AND EXISTS (SELECT 'X' FROM JTF_TAE_1001_ACCOUNT_NM_TRANS TRANS
581: SELECT distinct customer_id
582: FROM AS_CHANGED_ACCOUNTS_ALL CHNG
583: WHERE CHNG.lead_id IS NULL
584: AND CHNG.sales_lead_id IS NULL 585: AND EXISTS (SELECT 'X' FROM JTF_TAE_1001_ACCOUNT_NM_TRANS TRANS 586: WHERE TRANS.TRANS_OBJECT_ID = CHNG.CUSTOMER_ID);
587:
588: CURSOR del_lead_changed IS
589: SELECT distinct sales_lead_id