DBA Data[Home] [Help]

APPS.PSB_VALIDATE_DATA_EXTRACT_PVT dependencies on PSB_EMPLOYEES_I

Line 110: from psb_employees_i

106: add_message('PSB', 'PSB_VACANT_POSITIONS_COUNT');
107:
108: Select count(*)
109: into l_employee_cnt
110: from psb_employees_i
111: where data_extract_id = p_data_extract_id;
112:
113: message_token('EMPLOYEE_COUNT',l_employee_cnt );
114: add_message('PSB', 'PSB_EMPLOYEES_COUNT');

Line 318: from psb_employees_i pei,

314: pei.salary_type,pei.rate_or_payscale_id,
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