[Home] [Help]
3412: 'SEGMENT27',SEGMENT27,
3413: 'SEGMENT28',SEGMENT28,
3414: 'SEGMENT29',SEGMENT29,
3415: 'SEGMENT30',SEGMENT30) agency_code
3416: FROM per_position_definitions ppd, hr_all_positions_f pos
3417: WHERE pos.position_definition_id = ppd.position_definition_id
3418: AND pos.position_id = c_position_id
3419: AND c_effective_date BETWEEN pos.effective_start_date AND pos.effective_end_date;
3420: