APPS.DOM_SECURITY_PUB dependencies on FND_USER

Line 439: FROM FND_USER where person_party_id = p_party_ids(lcount);

435: INTO l_service_url, l_protocol
436: FROM DOM_REPOSITORIES WHERE id = l_node_id;
437:
438: SELECT user_name INTO l_user_name
439: FROM FND_USER where person_party_id = p_party_ids(lcount);
440:
441: SELECT party_type INTO l_party_type
442: FROM hz_parties
443: WHERE party_id = p_party_ids(lcount);

Line 452: FROM fnd_user

448:
449: --Get the Attachment created by user login.
450: -- This is required to make WS connection while trying to grant role to the user.
451: SELECT user_name INTO l_user_login
452: FROM fnd_user
453: WHERE user_id = l_created_by;
454:
455: IF (l_protocol = 'WEBSERVICES') THEN
456:

Line 602: from fnd_user

598:
599: cursor get_user_name(cp_user_id number)
600: IS
601: select user_name
602: from fnd_user
603: where user_id=cp_user_id;
604:
605: cursor get_user_name_from_party(cp_party_id number)
606: IS

Line 608: FROM FND_USER

604:
605: cursor get_user_name_from_party(cp_party_id number)
606: IS
607: SELECT user_name
608: FROM FND_USER
609: where person_party_id = cp_party_id ;
610:
611: BEGIN
612:

Line 783: FROM FND_USER where person_party_id = p_party_ids(lcount);

779: INTO l_service_url, l_protocol
780: FROM DOM_REPOSITORIES WHERE id = l_node_id ;
781:
782: SELECT user_name INTO l_user_name
783: FROM FND_USER where person_party_id = p_party_ids(lcount);
784:
785: --Get the Attachment created by user login.
786: -- This is required to make WS connection while trying to grant role to the user.
787: SELECT user_name INTO l_user_login

Line 788: FROM fnd_user

784:
785: --Get the Attachment created by user login.
786: -- This is required to make WS connection while trying to grant role to the user.
787: SELECT user_name INTO l_user_login
788: FROM fnd_user
789: WHERE user_id = l_created_by ;
790:
791: SELECT party_type INTO l_party_type
792: FROM hz_parties