DBA Data[Home] [Help]

APPS.AS_LEAD_ROUTING_WF_CUHK dependencies on JTF_TERR_RSC_ALL

Line 116: jtf_terr_rsc_all terrrsc

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
120: AND terracc.territory_id = terrrsc.terr_id