DBA Data[Home] [Help]

APPS.GHR_APPROVED_PA_REQUESTS dependencies on PER_PEOPLE_EXTRA_INFO

Line 107: FROM per_people_extra_info pei

103: ,pei.pei_information6 authorizer_flag
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'