DBA Data[Home] [Help]

APPS.PAY_IE_P45_ARCHIVE dependencies on HR_LOCATIONS_ALL

Line 3256: hr_locations_all hrl

3252: pay_payroll_actions pact,
3253: hr_organization_information org,
3254: hr_soft_coding_keyflex flex,
3255: hr_organization_units hou,
3256: hr_locations_all hrl
3257: WHERE org.org_information_context = 'IE_EMPLOYER_INFO' -- for migration changes 4369280
3258: AND ppf.business_group_id = hou.business_group_id
3259: AND org.organization_id = hou.organization_id
3260: AND hou.location_id = hrl.location_id(+)

Line 3312: ,hr_locations_all hrl

3308: --
3309: FROM hr_all_organization_units org_all
3310: ,hr_organization_information org_info
3311: -- ,pay_consolidation_sets pcs
3312: ,hr_locations_all hrl
3313: WHERE /*pcs.consolidation_set_id = c_consolidation_set
3314: AND org_all.organization_id = pcs.business_group_id
3315: AND org_info.organization_id = org_all.organization_id
3316: AND org_info.org_information_context = 'IE_ORG_INFORMATION'