APPS.PAY_DK_STATSR_PKG dependencies on HR_LOCATION_EXTRA_INFO

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

684:
685: rg_csr_get_hr_org_info csr_get_hr_org_info%rowtype;
686:
687: /* Cursor to fetch the Assgt location level Production Unit Code*/
688: CURSOR csr_location_info (p_location_id hr_location_extra_info.location_id%TYPE) IS
689: SELECT lei_information1
690: FROM hr_location_extra_info
691: WHERE location_id = p_location_id
692: AND information_type='DK_LOCATION_INFO';

Line 690: FROM hr_location_extra_info

686:
687: /* Cursor to fetch the Assgt location level Production Unit Code*/
688: CURSOR csr_location_info (p_location_id hr_location_extra_info.location_id%TYPE) IS
689: SELECT lei_information1
690: FROM hr_location_extra_info
691: WHERE location_id = p_location_id
692: AND information_type='DK_LOCATION_INFO';
693:
694: rg_csr_location_info csr_location_info%ROWTYPE;