eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_JP_EMPDET_REPORT_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 600: ,per_periods_of_service PPS

596: FROM per_assignments_f PAF
597: ,pay_assignment_actions PAA
598: ,per_people_f PPF
599: ,hr_all_organization_units HAOU
600: ,per_periods_of_service PPS
601: WHERE PAA.payroll_action_id = :pactid
602: AND PAF.assignment_id = PAA.assignment_id
603: AND PPF.person_id = PAF.person_id
604: AND PAF.organization_id = HAOU.organization_id

Line 695: ,per_periods_of_service PPS

691: ,pay_assignment_actions PAA
692: ,per_people_f PPF
693: ,hr_all_organization_units_tl HAOUT
694: ,hr_all_organization_units HAOU
695: ,per_periods_of_service PPS
696: WHERE PAA.payroll_action_id = :pactid
697: AND PAF.assignment_id = PAA.assignment_id
698: AND PPF.person_id = PAF.person_id
699: AND PAF.organization_id = HAOU.organization_id

Line 850: ,per_periods_of_service PPOF

846: FROM per_assignments_f PAA
847: ,per_people_f PAP
848: ,pay_assignment_actions PAS
849: ,per_jp_empdet_emp_v PJEDV
850: ,per_periods_of_service PPOF
851: ,pay_population_ranges PPR
852: ,pay_payroll_actions PPA
853: WHERE PAA.person_id = PAP.person_id
854: AND PPA.payroll_action_id = PPR.payroll_action_id

Line 903: ,per_periods_of_service PPS

899: ,PJEDV.effective_date
900: FROM per_assignments_f PAA
901: ,per_people_f PAP
902: ,pay_assignment_actions PAS
903: ,per_periods_of_service PPS
904: ,per_jp_empdet_emp_v PJEDV
905: WHERE PAA.person_id = PAP.person_id
906: AND PAA.person_id BETWEEN p_start_person_id
907: AND p_end_person_id