APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on HR_LOCATION_EXTRA_INFO

Line 1852: from hr_location_extra_info

1848: and pei_information1 = upper(p_doc_type);
1849:
1850: CURSOR get_loc_eit (l_location_id number) IS
1851: select lei_information2, lei_information3
1852: from hr_location_extra_info
1853: where information_type = 'HR_SELF_SERVICE_LOC_PREFERENCE'
1854: and location_id = l_location_id
1855: and lei_information1 = upper(p_doc_type);
1856: