DBA Data[Home] [Help]

APPS.PSB_HR_POPULATE_DATA_PVT dependencies on PSB_EMPLOYEES_I

Line 4512: psb_employees_i b,

4508: a.segment21, a.segment22, a.segment23, a.segment24, a.segment25,
4509: a.segment26, a.segment27, a.segment28, a.segment29, a.segment30,
4510: a.effective_start_date
4511: FROM psb_cost_distributions_i a,
4512: psb_employees_i b,
4513: psb_employees be,
4514: psb_positions c,
4515: psb_position_assignments d
4516: WHERE a.assignment_id = b.assignment_id

Line 6960: FROM psb_employees_i pe,

6956: salary_type,rate_or_payscale_id,
6957: element_value,proposed_salary,
6958: employee_number,
6959: pp.set_of_books_id
6960: FROM psb_employees_i pe,
6961: psb_positions pp
6962: WHERE pe.data_extract_id = p_data_extract_id
6963: AND pe.data_extract_id = pp.data_extract_id
6964: AND pe.hr_position_id = pp.hr_position_id

Line 8445: FROM psb_employees_i

8441: vacancy_flag varchar2(1) := 'N';
8442:
8443: BEGIN
8444: Select count(*) INTO lcount
8445: FROM psb_employees_i
8446: WHERE hr_position_id = p_position_id
8447: AND data_extract_id = p_data_extract_id;
8448:
8449: IF (lcount >= 1) THEN