APPS.DOM_WS_INTERFACE_PUB dependencies on FND_USER

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

317:
318: l_param_query_string VARCHAR2(2000);
319:
320: CURSOR user_info is
321: SELECT USER_NAME FROM fnd_user WHERE person_party_id = p_member_id;
322:
323: BEGIN
324: -- Standard Start of API savepoint
325: mdebug('. ADD_OFO_GROUP_MEMBER: ADD_OFO_GROUP_MEMBER .....1...... ');

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

340:
341: SELECT GROUP_NAME INTO l_group_name FROM EGO_GROUPS_V WHERE GROUP_ID = p_group_id;
342:
343: --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;
344: --SELECT USER_NAME INTO l_member_name FROM fnd_user WHERE person_party_id = p_member_id;
345: --SELECT USER_NAME INTO l_logged_in FROM FND_USER WHERE USER_ID = G_CURRENT_USER_ID;
346:
347: FOR info_rec IN user_info LOOP
348: l_member_name := info_rec.USER_NAME;

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

341: SELECT GROUP_NAME INTO l_group_name FROM EGO_GROUPS_V WHERE GROUP_ID = p_group_id;
342:
343: --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;
344: --SELECT USER_NAME INTO l_member_name FROM fnd_user WHERE person_party_id = p_member_id;
345: --SELECT USER_NAME INTO l_logged_in FROM FND_USER WHERE USER_ID = G_CURRENT_USER_ID;
346:
347: FOR info_rec IN user_info LOOP
348: l_member_name := info_rec.USER_NAME;
349: SELECT us.user_name INTO l_logged_in

Line 350: FROM hz_parties hz, fnd_user us

346:
347: FOR info_rec IN user_info LOOP
348: l_member_name := info_rec.USER_NAME;
349: SELECT us.user_name INTO l_logged_in
350: FROM hz_parties hz, fnd_user us
351: WHERE hz.created_by = us.USER_ID
352: AND party_id = p_group_id;
353:
354: