DBA Data[Home] [Help]

APPS.GHR_APPROVED_PA_REQUESTS dependencies on FND_USER

Line 108: ,fnd_user usr

104: ,pei.pei_information7 personnelist_flag
105: ,pei.pei_information8 approver_flag
106: ,pei.pei_information9 reviewer_flag
107: FROM per_people_extra_info pei
108: ,fnd_user usr
109: WHERE usr.user_name = p_user_name
110: AND pei.person_id = usr.employee_id
111: AND pei.information_type = 'GHR_US_PER_WF_ROUTING_GROUPS'
112: AND pei.pei_information3 = p_routing_group_id;