DBA Data[Home] [Help]

APPS.MSC_ATP_PUB dependencies on HZ_CUST_ACCOUNT_ROLES

Line 203: hz_cust_account_roles hcar

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
206: and hcar.cust_account_role_id = fnd.customer_id
207: and fnd.start_date <= trunc(sysdate)