DBA Data[Home] [Help]

APPS.MSC_ATP_PUB dependencies on FND_USER

Line 185: fnd_user fnd,

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
189: and ra.address_id = rsua.address_id

Line 194: and wf.orig_system_id = fnd.user_id

190: and ra.contact_id = fnd.customer_id
191: and fnd.start_date <= sysdate
192: and ( fnd.end_date IS NULL OR fnd.end_date >= trunc(sysdate))
193: and wf.orig_system = 'FND_USR'
194: and wf.orig_system_id = fnd.user_id
195: and wf.STATUS = 'ACTIVE';
196:
197: */
198: CURSOR C_CUSTCNT(p_cust_id number,

Line 202: fnd_user fnd,

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
206: and hcar.cust_account_role_id = fnd.customer_id

Line 210: and wf.orig_system_id = fnd.user_id

206: and hcar.cust_account_role_id = fnd.customer_id
207: and fnd.start_date <= trunc(sysdate)
208: and ( fnd.end_date IS NULL OR fnd.end_date >= trunc(sysdate))
209: and wf.orig_system = 'FND_USR'
210: and wf.orig_system_id = fnd.user_id
211: and wf.STATUS = 'ACTIVE';
212:
213: BEGIN
214: IF PG_DEBUG in ('Y', 'C') THEN