DBA Data[Home] [Help]

APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on HR_LOCATION_EXTRA_INFO

Line 1264: from hr_location_extra_info

1260: and pei_information1 = upper(p_doc_type);
1261:
1262: CURSOR get_loc_eit (l_location_id number) IS
1263: select lei_information2, lei_information3
1264: from hr_location_extra_info
1265: where information_type = 'HR_SELF_SERVICE_LOC_PREFERENCE'
1266: and location_id = l_location_id
1267: and lei_information1 = upper(p_doc_type);
1268: