DBA Data[Home] [Help]

APPS.PAY_DK_SICKNESS_DP202 dependencies on PER_ALL_PEOPLE_F

Line 153: per_all_people_f papf

149: /*Reopened Bug 5049222 fix*/
150: SUBSTR (papf.last_name,1,40)||', '||SUBSTR(papf.first_name,1,40)||NVL2(papf.middle_names,' '||SUBSTR(papf.middle_names,1,40),NULL) ename
151: ,papf.national_identifier national_identifier
152: FROM
153: per_all_people_f papf
154: WHERE
155: papf.person_id = p_person_id
156: AND p_effective_date between papf.effective_start_date and papf.effective_end_date
157: AND papf.current_employee_flag = 'Y')