DBA Data[Home] [Help]

APPS.MSC_SUPPLIER_PWB dependencies on FND_USER

Line 14: from fnd_user_resp_groups

10: return number is
11:
12: cursor c_user_resp (p_user number, p_resp number, p_app number) is
13: select count(*)
14: from fnd_user_resp_groups
15: where user_id = p_user
16: and responsibility_id= p_resp
17: and responsibility_application_id = p_app ;
18:

Line 408: from fnd_user fu,

404: FUNCTION modelled_as_org return boolean IS
405:
406: CURSOR c_org IS
407: select count(*)
408: from fnd_user fu,
409: msc_company_users mcu,
410: msc_trading_partner_maps map,
411: msc_company_relationships mcrs,
412: msc_trading_partners mtp

Line 439: from fnd_user fu,

435: FUNCTION modelled_as_supplier return number IS
436:
437: CURSOR c_sup IS
438: select mtp.sr_instance_id, mtp.partner_id
439: from fnd_user fu,
440: msc_company_users mcu,
441: msc_trading_partner_maps map,
442: msc_company_relationships mcrs,
443: msc_trading_partners mtp