DBA Data[Home] [Help]

APPS.MSC_SCE_LOADS_PKG dependencies on FND_RESPONSIBILITY

Line 53: fnd_responsibility_vl frv

49:
50: select 1
51: into lv_admin
52: from fnd_user_resp_groups furg,
53: fnd_responsibility_vl frv
54: where furg.USER_ID = pUSER_ID
55: and frv.RESPONSIBILITY_NAME like '%Supply Chain Collaboration Administrator%'
56: and frv.APPLICATION_ID = 724
57: and frv.APPLICATION_ID = furg.RESPONSIBILITY_APPLICATION_ID

Line 5113: fnd_responsibility r,

5109: SELECT DISTINCT u.user_name
5110: , u.user_id
5111: FROM fnd_user u,
5112: fnd_user_resp_groups g,
5113: fnd_responsibility r,
5114: msc_company_users cu,
5115: msc_companies c,
5116: msc_supdem_lines_interface ln
5117: WHERE ln.parent_header_id = p_header_id