APPS.AMV_MATCH_PVT dependencies on FND_USER

Line 1669: , fnd_user u

1665: CURSOR Get_OwnerIDAndName_csr (res_id IN NUMBER)IS
1666: select u.user_name,
1667: r.resource_id
1668: From amv_rs_all_res_extns_vl r
1669: , fnd_user u
1670: where r.resource_id = res_id
1671: and u.user_id = r.user_id;
1672: --
1673: CURSOR Get_ChannelInfo_csr IS

Line 2014: , fnd_user u

2010: CURSOR Get_OwnerIDAndName_csr (res_id IN NUMBER)IS
2011: select u.user_name,
2012: r.resource_id
2013: From amv_rs_all_res_extns_vl r
2014: , fnd_user u
2015: where r.resource_id = res_id
2016: and u.user_id = r.user_id;
2017: --
2018: CURSOR Get_ChannelInfo_csr IS

Line 2387: From fnd_user u, jtf_rs_resource_extns r, amv_c_channels_b c

2383: CURSOR Get_OwnerIDAndName_csr (p_id IN NUMBER)IS
2384: select
2385: u.user_name,
2386: c.owner_user_id
2387: From fnd_user u, jtf_rs_resource_extns r, amv_c_channels_b c
2388: Where c.channel_id = p_id
2389: And r.resource_id = c.owner_user_id
2390: And r.user_id = u.user_id
2391: ;