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 448: from fnd_user fu,

444: FUNCTION modelled_as_org return boolean IS
445:
446: CURSOR c_org IS
447: select count(*)
448: from fnd_user fu,
449: msc_company_users mcu,
450: msc_trading_partner_maps map,
451: msc_company_relationships mcrs,
452: msc_trading_partners mtp

Line 479: from fnd_user fu,

475: FUNCTION modelled_as_supplier return number IS
476:
477: CURSOR c_sup IS
478: select mtp.sr_instance_id, mtp.partner_id
479: from fnd_user fu,
480: msc_company_users mcu,
481: msc_trading_partner_maps map,
482: msc_company_relationships mcrs,
483: msc_trading_partners mtp