APPS.DOM_WS_INTERFACE_PUB dependencies on FND_USER

Line 246: SELECT USER_NAME FROM fnd_user WHERE person_party_id = p_member_id;

242:
243: l_param_query_string VARCHAR2(2000);
244:
245: CURSOR user_info is
246: SELECT USER_NAME FROM fnd_user WHERE person_party_id = p_member_id;
247:
248: BEGIN
249: -- Standard Start of API savepoint
250: mdebug('. ADD_OFO_GROUP_MEMBER: ADD_OFO_GROUP_MEMBER .....1...... ');

Line 269: --SELECT USER_NAME INTO l_member_name FROM fnd_user WHERE person_party_id = p_member_id;

265:
266: SELECT GROUP_NAME INTO l_group_name FROM EGO_GROUPS_V WHERE GROUP_ID = p_group_id;
267:
268: --SELECT MEMBER_USER_NAME INTO l_member_name FROM EGO_GROUP_MEMBERS_V WHERE GROUP_ID = p_group_id AND MEMBER_PERSON_ID = p_member_id;
269: --SELECT USER_NAME INTO l_member_name FROM fnd_user WHERE person_party_id = p_member_id;
270: --SELECT USER_NAME INTO l_logged_in FROM FND_USER WHERE USER_ID = G_CURRENT_USER_ID;
271:
272: FOR info_rec IN user_info LOOP
273: l_member_name := info_rec.USER_NAME;

Line 270: --SELECT USER_NAME INTO l_logged_in FROM FND_USER WHERE USER_ID = G_CURRENT_USER_ID;

266: SELECT GROUP_NAME INTO l_group_name FROM EGO_GROUPS_V WHERE GROUP_ID = p_group_id;
267:
268: --SELECT MEMBER_USER_NAME INTO l_member_name FROM EGO_GROUP_MEMBERS_V WHERE GROUP_ID = p_group_id AND MEMBER_PERSON_ID = p_member_id;
269: --SELECT USER_NAME INTO l_member_name FROM fnd_user WHERE person_party_id = p_member_id;
270: --SELECT USER_NAME INTO l_logged_in FROM FND_USER WHERE USER_ID = G_CURRENT_USER_ID;
271:
272: FOR info_rec IN user_info LOOP
273: l_member_name := info_rec.USER_NAME;
274: SELECT us.user_name INTO l_logged_in

Line 275: FROM hz_parties hz, fnd_user us

271:
272: FOR info_rec IN user_info LOOP
273: l_member_name := info_rec.USER_NAME;
274: SELECT us.user_name INTO l_logged_in
275: FROM hz_parties hz, fnd_user us
276: WHERE hz.created_by = us.USER_ID
277: AND party_id = p_group_id;
278:
279: