APPS.PAY_DK_ABSR_PKG dependencies on HR_LOCATION_EXTRA_INFO

Line 522: CURSOR csr_location_info (p_location_id hr_location_extra_info.location_id%TYPE) IS

518:
519: rg_csr_get_hr_org_info csr_get_hr_org_info%rowtype;
520:
521: /* Cursor to fetch the Assgt location level Production Unit Code*/
522: CURSOR csr_location_info (p_location_id hr_location_extra_info.location_id%TYPE) IS
523: SELECT lei_information1
524: FROM hr_location_extra_info
525: WHERE location_id = p_location_id
526: AND information_type='DK_LOCATION_INFO';

Line 524: FROM hr_location_extra_info

520:
521: /* Cursor to fetch the Assgt location level Production Unit Code*/
522: CURSOR csr_location_info (p_location_id hr_location_extra_info.location_id%TYPE) IS
523: SELECT lei_information1
524: FROM hr_location_extra_info
525: WHERE location_id = p_location_id
526: AND information_type='DK_LOCATION_INFO';
527:
528: rg_csr_location_info csr_location_info%ROWTYPE;