DBA Data[Home] [Help]

APPS.MSC_ATP_PUB dependencies on WF_ROLES

Line 184: wf_roles wf,

180: CURSOR C_CUSTCNT(p_cust_id number,
181: p_cust_site_id number) IS
182: select wf.name
183: from ra_site_uses_all rsua,
184: wf_roles wf,
185: fnd_user fnd,
186: ra_contacts ra
187: where ra.customer_id = p_cust_id
188: and rsua.site_use_id = p_cust_site_id

Line 201: from wf_roles wf,

197: */
198: CURSOR C_CUSTCNT(p_cust_id number,
199: p_cust_site_id number) IS
200: select wf.name
201: from wf_roles wf,
202: fnd_user fnd,
203: hz_cust_account_roles hcar
204: where hcar.cust_account_id = p_cust_id
205: and hcar.cust_acct_site_id = p_cust_site_id

Line 235: from wf_roles wf,

231: BEGIN
232:
233: select min(wf.name)
234: into l_sales_rep
235: from wf_roles wf,
236: oe_order_lines_all oe
237: where oe.line_id = p_atp_rec.identifier(i)
238: and wf.orig_system= 'PER'
239: and wf.orig_system_id= oe.salesrep_id