APPS.PAY_CA_RL2_REG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 181: hr_all_organization_units hou

177:
178: cursor c_first_tax_unit_id (l_pre_org_id varchar2) is
179: select distinct hoi.organization_id
180: from hr_organization_information hoi,
181: hr_all_organization_units hou
182: where hou.business_group_id = l_bus_group_id
183: and hou.organization_id = hoi.organization_id
184: and hoi.org_information_context = 'Canada Employer Identification'
185: and hoi.org_information2 = l_pre_org_id

Line 577: from hr_all_organization_units hou1,

573: begin
574: hr_utility.trace('Start of Sort_Action 1');
575:
576: sqlstr := 'select paa1.rowid /* we need the row id of the assignment actions that are created by PYUGEN */
577: from hr_all_organization_units hou1,
578: hr_all_organization_units hou,
579: hr_locations_all loc,
580: per_all_people_f ppf,
581: per_all_assignments_f paf,

Line 578: hr_all_organization_units hou,

574: hr_utility.trace('Start of Sort_Action 1');
575:
576: sqlstr := 'select paa1.rowid /* we need the row id of the assignment actions that are created by PYUGEN */
577: from hr_all_organization_units hou1,
578: hr_all_organization_units hou,
579: hr_locations_all loc,
580: per_all_people_f ppf,
581: per_all_assignments_f paf,
582: pay_assignment_actions paa1,