APPS.PSB_VALIDATE_DATA_EXTRACT_PVT dependencies on PSB_POSITIONS_I

Line 91: from psb_positions_i

87: p_return_status := FND_API.G_RET_STS_SUCCESS;
88:
89: Select count(*)
90: into l_positions
91: from psb_positions_i
92: where data_extract_id = p_data_extract_id
93: and hr_employee_id is not null;
94:
95: add_message('PSB','PSB_DE_SUMMARY_HEADER');

Line 101: from psb_positions_i pp

97: add_message('PSB', 'PSB_ASSIGNED_POSITIONS_COUNT');
98:
99: Select count(*)
100: into l_vacant_positions
101: from psb_positions_i pp
102: where pp.data_extract_id = p_data_extract_id
103: and hr_employee_id is null;
104:
105: message_token('VACANT_POSITION',l_vacant_positions );

Line 319: psb_positions_i pp

315: pei.grade_id,pei.grade_step,
316: pei.sequence_number,pei.element_value,
317: pei.proposed_salary
318: from psb_employees_i pei,
319: psb_positions_i pp
320: where pei.data_extract_id = p_data_extract_id
321: and pp.data_extract_id = p_data_extract_id
322: and pei.hr_position_id = pp.hr_position_id
323: and pei.hr_employee_id = pp.hr_employee_id