APPS.MSC_SCE_LOADS_PKG dependencies on FND_USER

Line 21: FROM fnd_user usr,

17: ) IS
18: BEGIN
19: SELECT usr.user_id
20: INTO p_user_id
21: FROM fnd_user usr,
22: ecx_doclogs ecx
23: WHERE usr.user_name = upper(ecx.username)
24: AND ecx.internal_control_number = p_int_control_number;
25: EXCEPTION

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 5111: FROM fnd_user u,

5107: p_header_id IN NUMBER
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,

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

Line 5317: FROM fnd_user u,

5313: SELECT distinct u.user_name,
5314: l.created_by
5315: INTO l_user_name,
5316: l_user_id
5317: FROM fnd_user u,
5318: msc_supdem_lines_interface l
5319: WHERE u.user_id = l.created_by and
5320: l.parent_header_id = p_header_id;
5321: