DBA Data[Home] [Help]

APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1810: FROM hr_all_organization_units org_all

1806: --Added for bug fix 3567562,mofified source of Employer statutory reporting name
1807: ,org_info.org_information8 employer_tax_rep_name
1808: ,pcs.business_group_id business_group_id
1809: --
1810: FROM hr_all_organization_units org_all
1811: ,hr_organization_information org_info
1812: ,pay_consolidation_sets pcs
1813: WHERE pcs.consolidation_set_id = c_consolidation_set
1814: AND org_all.organization_id = pcs.business_group_id

Line 2925: FROM hr_all_organization_units org_all

2921: --Added for bug fix 3567562,mofified source of Employer statutory reporting name
2922: ,org_all.name employer_tax_rep_name
2923: ,pcs.business_group_id business_group_id
2924: --
2925: FROM hr_all_organization_units org_all
2926: ,hr_organization_information org_info
2927: ,pay_consolidation_sets pcs
2928: ,hr_locations_all hrl
2929: WHERE pcs.consolidation_set_id = c_consolidation_set