DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on HR_ALL_POSITIONS_F

Line 2783: from hr_all_positions_f pos

2779: l_position_id number;
2780: begin
2781: select pos.position_id
2782: into l_position_id
2783: from hr_all_positions_f pos
2784: where pos.name = p_position_name
2785: and pos.business_group_id + 0 = p_business_group_id
2786: and p_effective_date between
2787: pos.effective_start_date and pos.effective_end_date;

Line 4112: from hr_all_positions_f pos

4108: l_ovn number;
4109: begin
4110: select pos.object_version_number
4111: into l_ovn
4112: from hr_all_positions_f pos
4113: where pos.name = p_position_name
4114: and pos.business_group_id + 0 = p_business_group_id
4115: and p_effective_date between
4116: pos.effective_start_date and pos.effective_end_date;