APPS.PAY_CA_RL2_REG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 222: hr_all_organization_units hou

218:
219: cursor c_first_tax_unit_id (l_pre_org_id varchar2) is
220: select distinct hoi.organization_id
221: from hr_organization_information hoi,
222: hr_all_organization_units hou
223: where hou.business_group_id = l_bus_group_id
224: and hou.organization_id = hoi.organization_id
225: and hoi.org_information_context = 'Canada Employer Identification'
226: and hoi.org_information2 = l_pre_org_id

Line 788: from hr_all_organization_units hou1,

784: begin
785: hr_utility.trace('Start of Sort_Action 1');
786:
787: sqlstr := 'select paa1.rowid /* we need the row id of the assignment actions that are created by PYUGEN */
788: from hr_all_organization_units hou1,
789: hr_all_organization_units hou,
790: hr_locations_all loc,
791: per_all_people_f ppf,
792: per_all_assignments_f paf,

Line 789: hr_all_organization_units hou,

785: hr_utility.trace('Start of Sort_Action 1');
786:
787: sqlstr := 'select paa1.rowid /* we need the row id of the assignment actions that are created by PYUGEN */
788: from hr_all_organization_units hou1,
789: hr_all_organization_units hou,
790: hr_locations_all loc,
791: per_all_people_f ppf,
792: per_all_assignments_f paf,
793: pay_assignment_actions paa1,