APPS.PAY_SE_ALECTA dependencies on HR_LOCATION_EXTRA_INFO
Line 2565: FROM hr_location_extra_info
2561: IS
2562: SELECT hr_general.decode_lookup ('SE_ALECTA_COST_CENTER'
2563: ,lei_information1
2564: ) "COST_CENTER" 2565: FROM hr_location_extra_info 2566: WHERE location_id = csr_v_location_id
2567: AND information_type = 'SE_ALECTA_DETAILS';
2568: BEGIN
2569: OPEN csr_get_details;