APPS.PSB_POSITIONS_PVT dependencies on PSB_EMPLOYEES

Line 4542: psb_employees emp

4538: pos.effective_end_date,
4539: pos.name ,
4540: emp.employee_number
4541: FROM psb_positions pos,
4542: psb_employees emp
4543: WHERE pos.data_extract_id = l_data_extract_id
4544: AND pos.hr_employee_id = emp.hr_employee_id(+)
4545: AND emp.data_extract_id(+) = l_data_extract_id
4546: ORDER BY name

Line 5767: FROM psb_employees emp, psb_position_assignments pavb

5763: IF p_worksheet_id IS NULL THEN
5764:
5765: SELECT emp.employee_id
5766: INTO l_emp_id
5767: FROM psb_employees emp, psb_position_assignments pavb
5768: WHERE pavb.position_id = p_position_id
5769: AND pavb.assignment_type = 'EMPLOYEE'
5770: AND emp.data_extract_id = p_data_extract_id
5771: AND emp.employee_id = pavb.employee_id

Line 5779: FROM psb_employees emp, psb_position_assignments pavb

5775:
5776: ELSE
5777: SELECT emp.employee_id
5778: INTO l_emp_id
5779: FROM psb_employees emp, psb_position_assignments pavb
5780: WHERE pavb.position_id = p_position_id
5781: AND pavb.assignment_type = 'EMPLOYEE'
5782: AND emp.data_extract_id = p_data_extract_id
5783: AND emp.employee_id = pavb.employee_id

Line 5817: FROM psb_employees emp, psb_position_assignments pavb

5813: IF p_worksheet_id IS NULL THEN
5814:
5815: SELECT emp.employee_number
5816: INTO l_emp_number
5817: FROM psb_employees emp, psb_position_assignments pavb
5818: WHERE pavb.position_id = p_position_id
5819: AND pavb.assignment_type = 'EMPLOYEE'
5820: AND emp.data_extract_id = p_data_extract_id
5821: AND emp.employee_id = pavb.employee_id

Line 5829: FROM psb_employees emp, psb_position_assignments pavb

5825:
5826: ELSE
5827: SELECT emp.employee_number
5828: INTO l_emp_number
5829: FROM psb_employees emp, psb_position_assignments pavb
5830: WHERE pavb.position_id = p_position_id
5831: AND pavb.assignment_type = 'EMPLOYEE'
5832: AND emp.data_extract_id = p_data_extract_id
5833: AND emp.employee_id = pavb.employee_id

Line 5868: FROM psb_employees emp, psb_position_assignments pavb

5864: IF p_worksheet_id IS NULL THEN
5865:
5866: SELECT emp.full_name
5867: INTO l_emp_name
5868: FROM psb_employees emp, psb_position_assignments pavb
5869: WHERE pavb.position_id = p_position_id
5870: AND pavb.assignment_type = 'EMPLOYEE'
5871: AND emp.data_extract_id = p_data_extract_id
5872: AND emp.employee_id = pavb.employee_id

Line 5880: FROM psb_employees emp, psb_position_assignments pavb

5876:
5877: ELSE
5878: SELECT emp.full_name
5879: INTO l_emp_name
5880: FROM psb_employees emp, psb_position_assignments pavb
5881: WHERE pavb.position_id = p_position_id
5882: AND pavb.assignment_type = 'EMPLOYEE'
5883: AND emp.data_extract_id = p_data_extract_id
5884: AND emp.employee_id = pavb.employee_id