DBA Data[Home] [Help]

APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on PER_PEOPLE_EXTRA_INFO

Line 1845: from per_people_extra_info

1841: RETURN varchar2 IS
1842:
1843: CURSOR get_person_eit (l_person_id Number) IS
1844: select pei_information2, pei_information3
1845: from per_people_extra_info
1846: where information_type = 'HR_SELF_SERVICE_PER_PREFERENCE'
1847: and person_id = l_person_id
1848: and pei_information1 = upper(p_doc_type);
1849: