APPS.MSC_SCE_LOADS_PKG dependencies on FND_USER_RESP_GROUPS

Line 52: from fnd_user_resp_groups furg,

48: BEGIN
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

Line 5112: fnd_user_resp_groups g,

5108: ) IS
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