DBA Data[Home] [Help]

APPS.CN_WEBSERVICE_PUB dependencies on JTF_RS_SALESREPS

Line 62: , jtf_rs_salesreps jrs

58: , jrs.salesrep_id
59: , jrs.org_id
60: FROM fnd_user fu
61: , jtf_rs_defresources_v jrd
62: , jtf_rs_salesreps jrs
63: WHERE fu.user_name = usr_name
64: AND jrd.user_id = fu.user_id
65: AND jrs.resource_id = jrd.resource_id
66: AND jrs.org_id = p_org_id;

Line 159: , jtf_rs_salesreps jrs

155: , jrs.salesrep_id
156: , jrs.org_id
157: FROM fnd_user fu
158: , jtf_rs_defresources_v jrd
159: , jtf_rs_salesreps jrs
160: WHERE fu.user_name = usr_name
161: AND jrd.user_id = fu.user_id
162: AND jrs.resource_id = jrd.resource_id
163: AND jrs.org_id = p_org_id;

Line 268: , jtf_rs_salesreps jrs

264: , jrs.salesrep_id
265: , jrs.org_id
266: FROM fnd_user fu
267: , jtf_rs_defresources_v jrd
268: , jtf_rs_salesreps jrs
269: WHERE fu.user_name = usr_name
270: AND jrd.user_id = fu.user_id
271: AND jrs.resource_id = jrd.resource_id
272: AND jrs.org_id = p_org_id;