827: --
828: cursor csr_valid_pos is
829: select hp.business_group_id
830: from hr_all_positions_f hp 831: , per_shared_types ps 832: where hp.position_id = p_position_id
833: and p_effective_date
834: between hp.effective_start_date
835: and hp.effective_end_date
[Home] [Help]