APPS.AS_GAR_OPPTYS_PUB dependencies on JTF_TAE_1001_OPPOR_NM_TRANS

Line 1436: FROM JTF_TAE_1001_OPPOR_NM_TRANS

1432: WHERE worker_id=c_worker_id;
1433:
1434: CURSOR del_oppty_newmode(c_worker_id number) IS
1435: SELECT distinct trans_object_id
1436: FROM JTF_TAE_1001_OPPOR_NM_TRANS
1437: WHERE worker_id=c_worker_id;
1438:
1439: BEGIN
1440: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_START);

Line 1690: FROM JTF_TAE_1001_OPPOR_NM_TRANS

1686: SELECT /*+ index(aaa as_accesses_n3) */ aaa.lead_id ,
1687: max(decode(aaa.created_by_tap_flag,'Y',aaa.access_id,-999)) access_id
1688: FROM AS_ACCESSES_ALL_ALL aaa,
1689: ( SELECT distinct trans_object_id
1690: FROM JTF_TAE_1001_OPPOR_NM_TRANS
1691: WHERE worker_id=c_worker_id ) w
1692: WHERE aaa.lead_id IS NOT null
1693: AND aaa.sales_lead_id IS NULL
1694: AND aaa.delete_flag IS NULL

Line 1702: FROM JTF_TAE_1001_OPPOR_NM_TRANS w

1698: HAVING SUM(DECODE(aaa.CREATED_BY_TAP_FLAG,'Y',1,0)) > 0
1699: AND SUM(DECODE(aaa.owner_flag,'Y',1,0)) = 0
1700: UNION -- Union added for Bug#4035168
1701: SELECT trans_object_id ,0
1702: FROM JTF_TAE_1001_OPPOR_NM_TRANS w
1703: WHERE worker_id = c_worker_id
1704: AND NOT EXISTS
1705: (SELECT 'x'
1706: FROM AS_ACCESSES_ALL aaa