APPS.PAY_AU_REC_DET_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 344: hr_organization_units hou,

340: per_assignments_f paaf,
341: pay_payroll_actions ppa,
342: pay_payroll_actions ppa1,
343: pay_assignment_actions paa,
344: hr_organization_units hou,
345: per_periods_of_service pps
346: -- ,per_assignment_status_types past
347: where ppa.payroll_action_id = c_payroll_action_id
348: and paa.assignment_id = paaf.assignment_id

Line 397: hr_organization_units hou,

393: per_assignments_f paaf,
394: pay_payroll_actions ppa,
395: pay_payroll_actions ppa1,
396: pay_assignment_actions paa,
397: hr_organization_units hou,
398: per_periods_of_service pps
399: where ppa.payroll_action_id = c_payroll_action_id
400: and paa.assignment_id = paaf.assignment_id
401: and pap.person_id between c_start_person and c_end_person

Line 1575: hr_organization_units hou, /*Bug 3953706 */

1571: per_pay_bases ppb,
1572: per_pay_proposals pro,
1573: per_assignment_status_types past,
1574: hr_soft_coding_keyflex hsc, /*Bug 4040688*/
1575: hr_organization_units hou, /*Bug 3953706 */
1576: hr_organization_units hou1 /*Bug 4132525*/
1577: -- pay_payrolls_f papf /*Bug 4132525, Bug 4688872*/
1578: where pap.person_id = paa.person_id
1579: and paa.assignment_id = c_assignment_id

Line 1576: hr_organization_units hou1 /*Bug 4132525*/

1572: per_pay_proposals pro,
1573: per_assignment_status_types past,
1574: hr_soft_coding_keyflex hsc, /*Bug 4040688*/
1575: hr_organization_units hou, /*Bug 3953706 */
1576: hr_organization_units hou1 /*Bug 4132525*/
1577: -- pay_payrolls_f papf /*Bug 4132525, Bug 4688872*/
1578: where pap.person_id = paa.person_id
1579: and paa.assignment_id = c_assignment_id
1580: and paa.business_group_id = c_business_group_id