DBA Data[Home] [Help]

APPS.GHR_APPROVED_PA_REQUESTS dependencies on PER_PEOPLE_EXTRA_INFO

Line 116: FROM per_people_extra_info pei

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