APPS.PAY_AU_RECONCILIATION_PKG dependencies on HR_ORGANIZATION_UNITS

Line 530: hr_organization_units hou,

526: per_assignments_f paaf,
527: pay_payroll_actions ppa,
528: pay_payroll_actions ppa1,
529: pay_assignment_actions paa,
530: hr_organization_units hou,
531: per_periods_of_service pps
532: where ppa.payroll_action_id = c_payroll_action_id
533: and paa.assignment_id = paaf.assignment_id
534: and pap.person_id between c_start_person and c_end_person

Line 583: hr_organization_units hou,

579: per_assignments_f paaf,
580: pay_payroll_actions ppa,
581: pay_payroll_actions ppa1,
582: pay_assignment_actions paa,
583: hr_organization_units hou,
584: per_periods_of_service pps
585: where ppa.payroll_action_id = c_payroll_action_id
586: and paa.assignment_id = paaf.assignment_id
587: and pap.person_id between c_start_person and c_end_person

Line 1763: hr_organization_units hou, /*Bug 4132525*/

1759: hou1.NAME Legal_Employer /*Bug 4132525*/
1760: from per_people_f pap,
1761: per_assignments_f paa,
1762: hr_soft_coding_keyflex hsc, /*Bug 4040688*/
1763: hr_organization_units hou, /*Bug 4132525*/
1764: hr_organization_units hou1 /*Bug 4132525*/
1765: -- pay_payrolls_f papf /*Bug 4132525, Bug 4688800*/
1766: where pap.person_id = paa.person_id
1767: and paa.assignment_id = c_assignment_id

Line 1764: hr_organization_units hou1 /*Bug 4132525*/

1760: from per_people_f pap,
1761: per_assignments_f paa,
1762: hr_soft_coding_keyflex hsc, /*Bug 4040688*/
1763: hr_organization_units hou, /*Bug 4132525*/
1764: hr_organization_units hou1 /*Bug 4132525*/
1765: -- pay_payrolls_f papf /*Bug 4132525, Bug 4688800*/
1766: where pap.person_id = paa.person_id
1767: and paa.assignment_id = c_assignment_id
1768: and paa.business_group_id = c_business_group_id