DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on HR_ALL_POSITIONS_F

Line 2756: from hr_all_positions_f pos

2752: l_position_id number;
2753: begin
2754: select pos.position_id
2755: into l_position_id
2756: from hr_all_positions_f pos
2757: where pos.name = p_position_name
2758: and pos.business_group_id + 0 = p_business_group_id
2759: and p_effective_date between
2760: pos.effective_start_date and pos.effective_end_date;

Line 4085: from hr_all_positions_f pos

4081: l_ovn number;
4082: begin
4083: select pos.object_version_number
4084: into l_ovn
4085: from hr_all_positions_f pos
4086: where pos.name = p_position_name
4087: and pos.business_group_id + 0 = p_business_group_id
4088: and p_effective_date between
4089: pos.effective_start_date and pos.effective_end_date;