APPS.JTF_TTY_POP_TERR_ADMIN_BIN_PVT dependencies on AS_TERRITORY_ACCESSES

Line 66: , as_territory_accesses ATA

62: SELECT /*+ INDEX (AAA as_accesses_u1) */ COUNT(*)
63: INTO L_ACCOUNTS
64: FROM
65: as_accesses_all AAA
66: , as_territory_accesses ATA
67: WHERE AAA.ACCESS_ID = ATA.ACCESS_ID
68: AND ATA.TERRITORY_ID = l_list.terr_id
69: AND LEAD_ID IS NULL
70: AND SALES_LEAD_ID IS NULL

Line 78: , as_territory_accesses ATA

74: SELECT /*+ INDEX (AAA as_accesses_u1) */ COUNT(*)
75: INTO L_LEADS
76: FROM
77: as_accesses_all AAA
78: , as_territory_accesses ATA
79: WHERE AAA.ACCESS_ID = ATA.ACCESS_ID
80: AND ATA.TERRITORY_ID = l_list.terr_id
81: AND LEAD_ID IS NULL
82: AND SALES_LEAD_ID IS NOT NULL;

Line 90: , as_territory_accesses ATA

86: SELECT /*+ INDEX (AAA as_accesses_u1) */ COUNT(*)
87: INTO L_OPPORTUNITIES
88: FROM
89: as_accesses_all AAA
90: , as_territory_accesses ATA
91: WHERE AAA.ACCESS_ID = ATA.ACCESS_ID
92: AND ATA.TERRITORY_ID = l_list.terr_id
93: AND LEAD_ID IS NOT NULL
94: AND SALES_LEAD_ID IS NULL;