APPS.PAY_CA_EOY_T4A_AMEND_REG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 495: hr_all_organization_units hou

491: CURSOR c_all_gres(cp_bg_id number,
492: cp_eff_date date) IS
493: select hou.organization_id
494: from hr_organization_information hoi,
495: hr_all_organization_units hou
496: where hou.business_group_id = cp_bg_id
497: AND hou.organization_id = hoi.organization_id
498: AND hou.date_from <= cp_eff_date
499: AND nvl(hou.date_to,fnd_date.canonical_to_date('4712/12/31 00:00:00'))

Line 1642: from hr_all_organization_units hou,

1638: begin
1639: hr_utility.trace('Beginning of the sort_action cursor');
1640:
1641: sqlstr := 'select paa1.rowid
1642: from hr_all_organization_units hou,
1643: hr_all_organization_units hou1,
1644: hr_locations_all loc,
1645: per_all_people_f ppf,
1646: per_all_assignments_f paf,

Line 1643: hr_all_organization_units hou1,

1639: hr_utility.trace('Beginning of the sort_action cursor');
1640:
1641: sqlstr := 'select paa1.rowid
1642: from hr_all_organization_units hou,
1643: hr_all_organization_units hou1,
1644: hr_locations_all loc,
1645: per_all_people_f ppf,
1646: per_all_assignments_f paf,
1647: pay_assignment_actions paa1,