DBA Data[Home] [Help]

APPS.GHR_APPROVED_PA_REQUESTS dependencies on FND_USER

Line 117: ,fnd_user usr

113: ,pei.pei_information7 personnelist_flag
114: ,pei.pei_information8 approver_flag
115: ,pei.pei_information9 reviewer_flag
116: FROM per_people_extra_info pei
117: ,fnd_user usr
118: WHERE usr.user_name = p_user_name
119: AND pei.person_id = usr.employee_id
120: AND pei.information_type = 'GHR_US_PER_WF_ROUTING_GROUPS'
121: AND pei.pei_information3 = p_routing_group_id;