5008: ,target.org_information4
5009: ,target.org_information5
5010: ,target.org_information6
5011: ,target.org_information7
5012: from hr_organization_information target
5013: ,per_all_assignments_f assign
5014: WHERE p_date_earned BETWEEN assign.effective_start_date AND assign.effective_end_date
5015: AND assign.assignment_id = p_assignment_id
5016: AND assign.establishment_id = target.organization_id
5028: ,target.org_information5
5029: ,target.org_information6
5030: ,target.org_information7
5031: from hr_organization_units comp
5032: ,hr_organization_information target
5033: ,hr_organization_information estab
5034: ,per_all_assignments_f assign
5035: WHERE p_date_earned BETWEEN assign.effective_start_date AND assign.effective_end_date
5036: AND assign.assignment_id = p_assignment_id
5029: ,target.org_information6
5030: ,target.org_information7
5031: from hr_organization_units comp
5032: ,hr_organization_information target
5033: ,hr_organization_information estab
5034: ,per_all_assignments_f assign
5035: WHERE p_date_earned BETWEEN assign.effective_start_date AND assign.effective_end_date
5036: AND assign.assignment_id = p_assignment_id
5037: AND assign.establishment_id = estab.organization_id