DBA Data[Home] [Help]

APPS.PAY_JP_UITE_REPORT_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 700: ,hr_all_organization_units HAOU

696: ,pay_jp_uite_emp_v PJUIEV
697: ,per_periods_of_service PPOF
698: ,pay_population_ranges PPR
699: ,pay_payroll_actions PPA
700: ,hr_all_organization_units HAOU
701: WHERE PAA.person_id = PAP.person_id
702: AND PPA.payroll_action_id = PPR.payroll_action_id
703: AND PPR.person_id = PAP.person_id
704: AND PAS.assignment_id = PAA.assignment_id

Line 731: ,hr_all_organization_units HAOU

727: ,per_people_f PAP
728: ,pay_assignment_actions PAS
729: ,pay_jp_uite_emp_v PJUIEV
730: ,per_periods_of_service PPOF
731: ,hr_all_organization_units HAOU
732: WHERE PAA.person_id = PAP.person_id
733: AND PAA.person_id BETWEEN p_start_person_id
734: AND p_end_person_id
735: AND PAS.assignment_id = PAA.assignment_id

Line 1592: ,hr_all_organization_units_tl HAOUT

1588: sqlstr := ' SELECT PAA.rowid
1589: FROM per_assignments_f PAF
1590: ,pay_assignment_actions PAA
1591: ,per_people_f PPF
1592: ,hr_all_organization_units_tl HAOUT
1593: ,hr_all_organization_units HAOU
1594: ,per_periods_of_service PPS
1595: WHERE PAA.payroll_action_id = :pactid
1596: AND PAF.assignment_id = PAA.assignment_id

Line 1593: ,hr_all_organization_units HAOU

1589: FROM per_assignments_f PAF
1590: ,pay_assignment_actions PAA
1591: ,per_people_f PPF
1592: ,hr_all_organization_units_tl HAOUT
1593: ,hr_all_organization_units HAOU
1594: ,per_periods_of_service PPS
1595: WHERE PAA.payroll_action_id = :pactid
1596: AND PAF.assignment_id = PAA.assignment_id
1597: AND PPF.person_id = PAF.person_id