DBA Data[Home] [Help]

APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2097: FROM hr_all_organization_units org_all

2093: --Added for bug fix 3567562,mofified source of Employer statutory reporting name
2094: ,org_info.org_information8 employer_tax_rep_name
2095: ,pcs.business_group_id business_group_id
2096: --
2097: FROM hr_all_organization_units org_all
2098: ,hr_organization_information org_info
2099: ,pay_consolidation_sets pcs
2100: WHERE pcs.consolidation_set_id = c_consolidation_set
2101: AND org_all.organization_id = pcs.business_group_id

Line 3240: FROM hr_all_organization_units org_all

3236: --Added for bug fix 3567562,mofified source of Employer statutory reporting name
3237: ,org_all.name employer_tax_rep_name
3238: ,pcs.business_group_id business_group_id
3239: --
3240: FROM hr_all_organization_units org_all
3241: ,hr_organization_information org_info
3242: ,pay_consolidation_sets pcs
3243: ,hr_locations_all hrl
3244: WHERE pcs.consolidation_set_id = c_consolidation_set