DBA Data[Home] [Help]

APPS.PER_JP_WRKREG_REPORT_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 443: ,per_periods_of_service PPS

439: ,pay_assignment_actions PAA
440: ,per_people_f PPF
441: ,hr_all_organization_units_tl HAOUT
442: ,hr_all_organization_units HAOU
443: ,per_periods_of_service PPS
444: WHERE PAA.payroll_action_id = :pactid
445: AND PAF.assignment_id = PAA.assignment_id
446: AND PPF.person_id = PAF.person_id
447: AND PAF.organization_id = HAOU.organization_id

Line 607: ,per_periods_of_service PPOF

603: FROM per_assignments_f PAA
604: ,per_people_f PAP
605: ,pay_assignment_actions PAS
606: ,per_jp_wrkreg_emp_v PJWREV
607: ,per_periods_of_service PPOF
608: ,pay_population_ranges PPR
609: ,pay_payroll_actions PPA
610: ,hr_all_organization_units HAOU
611: WHERE PAA.person_id = PAP.person_id

Line 663: ,per_periods_of_service PPOF

659: FROM per_assignments_f PAA
660: ,per_people_f PAP
661: ,pay_assignment_actions PAS
662: ,per_jp_wrkreg_emp_v PJWREV
663: ,per_periods_of_service PPOF
664: ,hr_all_organization_units HAOU
665: WHERE PAA.person_id = PAP.person_id
666: AND PAA.person_id BETWEEN p_start_person_id
667: AND p_end_person_id