APPS.AS_LEAD_ROUTING_WF_CUHK dependencies on AS_TERRITORY_ACCESSES

Line 115: FROM as_accesses_all acc, as_territory_accesses terracc,

111: CURSOR c_get_terr_resource1(c_sales_lead_id NUMBER, c_party_id NUMBER,
112: c_party_site_id NUMBER, c_lead VARCHAR2,
113: c_account VARCHAR2) IS
114: SELECT acc.salesforce_id, acc.sales_group_id
115: FROM as_accesses_all acc, as_territory_accesses terracc,
116: jtf_terr_rsc_all terrrsc
117: WHERE acc.sales_lead_id = c_sales_lead_id
118: AND acc.created_by_tap_flag = 'Y'
119: AND acc.access_id = terracc.access_id