APPS.PAY_CA_EOY_RL1_AMEND_REG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 502: hr_all_organization_units hou

498: CURSOR c_all_pres(cp_bg_id number,
499: cp_eff_date date) IS
500: select hou.organization_id
501: from hr_organization_information hoi,
502: hr_all_organization_units hou
503: where hou.business_group_id = cp_bg_id
504: AND hou.organization_id = hoi.organization_id
505: AND hou.date_from <= cp_eff_date
506: AND nvl(hou.date_to,fnd_date.canonical_to_date('4712/12/31 00:00:00'))

Line 1672: from hr_all_organization_units hou1,

1668:
1669: hr_utility.trace('Beginning of the sort_action cursor');
1670:
1671: sqlstr := 'select paa1.rowid /* we need the row id of the assignment actions that are created by PYUGEN */
1672: from hr_all_organization_units hou1,
1673: hr_all_organization_units hou,
1674: hr_locations_all loc,
1675: per_all_people_f ppf,
1676: per_all_assignments_f paf,

Line 1673: hr_all_organization_units hou,

1669: hr_utility.trace('Beginning of the sort_action cursor');
1670:
1671: sqlstr := 'select paa1.rowid /* we need the row id of the assignment actions that are created by PYUGEN */
1672: from hr_all_organization_units hou1,
1673: hr_all_organization_units hou,
1674: hr_locations_all loc,
1675: per_all_people_f ppf,
1676: per_all_assignments_f paf,
1677: pay_assignment_actions paa1,