APPS.GHR_VALIDATE_PERWSDPO dependencies on HR_ALL_POSITIONS_F

Line 18: update hr_all_positions_f pos

14: l_name varchar2(240);
15: l_warning boolean;
16: l_pos_def_id number;
17: BEGIN
18: update hr_all_positions_f pos
19: set status = 'VALID'
20: where pos.position_id = p_position_id
21: and p_effective_date between pos.effective_STart_date and pos.effective_end_date
22: and pos.status <> 'VALID';

Line 86: from hr_all_positions_f pos

82: where poei.position_id=p_position_id and poei.information_type='GHR_US_POS_VALID_GRADE';
83:
84: cursor c_pos_table is
85: select pos.job_id, pos.business_group_id
86: from hr_all_positions_f pos
87: where pos.position_id= p_position_id
88: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
89:
90: cursor c_pos_desc_table is