APPS.AS_GAR_LEADS_PUB dependencies on JTF_TAE_1001_LEAD_TRANS

Line 1436: FROM JTF_TAE_1001_LEAD_TRANS

1432:
1433:
1434: CURSOR del_lead_totalmode(c_worker_id number) IS
1435: SELECT distinct trans_object_id
1436: FROM JTF_TAE_1001_LEAD_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

Line 1652: FROM JTF_TAE_1001_LEAD_TRANS

1648: SELECT /*+ index(aaa as_accesses_n6) */ aaa.sales_lead_id ,
1649: max(DECODE(aaa.created_by_tap_flag,'Y',aaa.access_id,-999)) access_id
1650: FROM AS_ACCESSES_ALL_ALL aaa,
1651: ( SELECT distinct trans_object_id
1652: FROM JTF_TAE_1001_LEAD_TRANS
1653: WHERE worker_id=c_worker_id ) w
1654: WHERE aaa.lead_id is NULL
1655: AND aaa.sales_lead_id is NOT NULL
1656: AND aaa.delete_flag is NULL

Line 1664: FROM JTF_TAE_1001_LEAD_TRANS w

1660: HAVING SUM(DECODE(aaa.CREATED_BY_TAP_FLAG,'Y',1,0)) > 0
1661: AND SUM(DECODE(aaa.owner_flag,'Y',1,0)) = 0
1662: UNION -- Union added for Bug#4035168
1663: SELECT trans_object_id ,0
1664: FROM JTF_TAE_1001_LEAD_TRANS w
1665: WHERE worker_id = c_worker_id
1666: AND NOT EXISTS
1667: (SELECT 'x'
1668: FROM AS_ACCESSES_ALL aaa