DBA Data[Home] [Help]

APPS.PAY_IE_P45_ARCHIVE dependencies on HR_LOCATIONS_ALL

Line 2550: hr_locations_all hrl

2546: pay_payroll_actions pact,
2547: hr_organization_information org,
2548: hr_soft_coding_keyflex flex,
2549: hr_organization_units hou,
2550: hr_locations_all hrl
2551: WHERE org.org_information_context = 'IE_EMPLOYER_INFO' -- for migration changes 4369280
2552: AND ppf.business_group_id = hou.business_group_id
2553: AND org.organization_id = hou.organization_id
2554: AND hou.location_id = hrl.location_id(+)

Line 2606: ,hr_locations_all hrl

2602: --
2603: FROM hr_all_organization_units org_all
2604: ,hr_organization_information org_info
2605: -- ,pay_consolidation_sets pcs
2606: ,hr_locations_all hrl
2607: WHERE /*pcs.consolidation_set_id = c_consolidation_set
2608: AND org_all.organization_id = pcs.business_group_id
2609: AND org_info.organization_id = org_all.organization_id
2610: AND org_info.org_information_context = 'IE_ORG_INFORMATION'