APPS.PSB_HR_POPULATE_DATA_PVT dependencies on PSB_EMPLOYEE_ASSIGNMENTS_I

Line 9142: -- assignment inFORmation FROM psb_employee_assignments_i

9138: l_currency_code := C_currency_rec.currency_code;
9139: END LOOP;
9140: --
9141: -- Process all the employees FROM psb_employees along with their ATTRIBUTE
9142: -- assignment inFORmation FROM psb_employee_assignments_i
9143: --
9144: FOR C_Assignment_Rec in
9145: (
9146: /*For Bug No : 2109120 Start*/

Line 9154: FROM psb_employee_assignments_i pea,

9150: pea.attribute_name,
9151: pea.attribute_value,
9152: pea.effective_start_DATE,
9153: pea.effective_END_DATE
9154: FROM psb_employee_assignments_i pea,
9155: psb_employees pe
9156: WHERE pea.data_extract_id = p_data_extract_id
9157: AND pe.hr_employee_id(+) = pea.hr_employee_id
9158: AND pe.data_extract_id(+) = p_data_extract_id

Line 9173: psb_employee_assignments_i pea

9169: pea.effective_start_DATE,
9170: pea.effective_END_DATE
9171: FROM psb_positions pp,
9172: psb_position_assignments ppa,
9173: psb_employee_assignments_i pea
9174: WHERE pp.data_extract_id = p_data_extract_id
9175: AND pp.position_id = ppa.position_id
9176: AND ppa.assignment_type = 'EMPLOYEE'
9177: AND ppa.employee_id IS NOT NULL

Line 9192: FROM psb_employee_assignments_i pea,

9188: pea.attribute_name,
9189: pea.attribute_value,
9190: pea.effective_start_DATE,
9191: pea.effective_END_DATE
9192: FROM psb_employee_assignments_i pea,
9193: psb_positions pp
9194: WHERE pea.data_extract_id = p_data_extract_id
9195: AND pea.hr_position_id = pp.hr_position_id
9196: AND pea.hr_employee_id IS NULL