36: cursor c_positions(p_organization_id number, p_effective_date date) is
37: select
38: pos.position_id, pos.job_id, name
39: from
40: hr_all_positions_f_vl pos
41: where
42: pos.organization_id = p_organization_id
43: and p_effective_date between pos.effective_start_date and pos.effective_end_date
44: order by position_id;
671: --
672: -- PMFLETCH Now selects from MLS view
673: cursor c_positions(p_organization_id number, p_effective_date date) is
674: select pos.position_id, pos.job_id, name
675: from hr_all_positions_f_vl pos
676: where pos.organization_id = p_organization_id
677: and p_effective_date between pos.effective_start_date and pos.effective_end_date
678: order by position_id;
679: --