[Home] [Help]
2989: IS
2990: SELECT hr_general.decode_lookup ('SE_ALECTA_COST_CENTER'
2991: ,lei_information1
2992: ) "COST_CENTER"
2993: FROM hr_location_extra_info
2994: WHERE location_id = csr_v_location_id
2995: AND information_type = 'SE_ALECTA_DETAILS';
2996: BEGIN
2997: OPEN csr_get_details;