DBA Data[Home] [Help]

APPS.PAY_FR_PTO_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 5012: from hr_organization_information target

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

Line 5032: ,hr_organization_information target

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

Line 5033: ,hr_organization_information estab

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