DBA Data[Home] [Help]

APPS.GHR_WF_PD_PKG dependencies on FND_USER

Line 639: p_user_name IN fnd_user.user_name%TYPE

635: end;
636: --
637: --
638: PROCEDURE get_routing_group_details (
639: p_user_name IN fnd_user.user_name%TYPE
640: ,p_position_description_id IN
641: ghr_position_descriptions.position_description_id%TYPE
642: ,p_routing_group_id IN OUT NOCOPY NUMBER
643: ,p_initiator_flag IN OUT NOCOPY VARCHAR2

Line 659: ,fnd_user use

655: ,pei.pei_information7 personnelist_flag
656: ,pei.pei_information8 approver_flag
657: ,pei.pei_information9 reviewer_flag
658: FROM per_people_extra_info pei
659: ,fnd_user use
660: WHERE use.user_name = p_user_name
661: AND pei.person_id = use.employee_id
662: AND pei.information_type = 'GHR_US_PER_WF_ROUTING_GROUPS'
663: AND pei.pei_information3 = (SELECT routing_group_id from