APPS.AS_GAR_LEADS_PUB dependencies on JTF_TAE_1001_LEAD_NM_TRANS

Line 1441: FROM JTF_TAE_1001_LEAD_NM_TRANS

1437: WHERE worker_id=c_worker_id;
1438:
1439: CURSOR del_lead_newmode(c_worker_id number) IS
1440: SELECT distinct trans_object_id
1441: FROM JTF_TAE_1001_LEAD_NM_TRANS
1442: WHERE worker_id=c_worker_id;
1443:
1444: BEGIN
1445: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_START);

Line 1679: FROM JTF_TAE_1001_LEAD_NM_TRANS

1675: SELECT /*+ index(aaa as_accesses_n6) */ aaa.sales_lead_id ,
1676: max(DECODE(aaa.created_by_tap_flag,'Y',aaa.access_id,-999)) access_id
1677: FROM AS_ACCESSES_ALL_ALL aaa,
1678: ( SELECT distinct trans_object_id
1679: FROM JTF_TAE_1001_LEAD_NM_TRANS
1680: WHERE worker_id=c_worker_id ) w
1681: WHERE aaa.lead_id is null
1682: AND aaa.delete_flag is null
1683: AND aaa.sales_lead_id=w.trans_object_id

Line 1690: FROM JTF_TAE_1001_LEAD_NM_TRANS w

1686: HAVING SUM(DECODE(aaa.CREATED_BY_TAP_FLAG,'Y',1,0)) > 0
1687: AND SUM(DECODE(aaa.owner_flag,'Y',1,0)) = 0
1688: UNION -- Union added for Bug#4035168
1689: SELECT trans_object_id ,0
1690: FROM JTF_TAE_1001_LEAD_NM_TRANS w
1691: WHERE worker_id = c_worker_id
1692: AND NOT EXISTS
1693: (SELECT 'x'
1694: FROM AS_ACCESSES_ALL aaa