DBA Data[Home] [Help]

APPS.PAY_JP_UITE_REPORT_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 697: ,per_periods_of_service PPOF

693: FROM per_assignments_f PAA
694: ,per_people_f PAP
695: ,pay_assignment_actions PAS
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

Line 730: ,per_periods_of_service PPOF

726: FROM per_assignments_f PAA
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

Line 1594: ,per_periods_of_service PPS

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
1598: AND PAF.organization_id = HAOU.organization_id