DBA Data[Home] [Help]

APPS.PAY_IE_P45_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 2547: hr_organization_information org,

2543: hrl.telephone_number_1 employer_tax_ref_phone
2544: --
2545: FROM pay_all_payrolls_f ppf,
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

Line 2604: ,hr_organization_information org_info

2600: org_all.name employer_tax_rep_name,
2601: org_all.business_group_id business_group_id
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