[Home] [Help]
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;