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.PAY_JP_IWHT_ARCH_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 627: ,per_periods_of_service PPS

623: SELECT PAF.assignment_id
624: ,PPS.actual_termination_date
625: FROM per_assignments_f PAF
626: ,per_people_f PPF
627: ,per_periods_of_service PPS
628: ,pay_population_ranges PPR
629: ,pay_payroll_actions PPA
630: WHERE PAF.person_id = PPF.person_id
631: AND PPF.person_id = PPS.person_id

Line 685: ,per_periods_of_service PPS

681: SELECT PAF.assignment_id
682: ,PPS.actual_termination_date
683: FROM per_assignments_f PAF
684: ,per_people_f PPF
685: ,per_periods_of_service PPS
686: WHERE PAF.person_id = PPF.person_id
687: AND PPF.person_id = PPS.person_id
688: AND PAF.business_group_id = p_business_group_id
689: AND PPS.period_of_service_id = NVL(PAF.period_of_service_id,PPS.period_of_service_id)

Line 966: , per_periods_of_service PPS

962: ,DECODE(PADR.address_id,NULL,PADC.address_line2 ,PADR.address_line2) address_line2
963: ,DECODE(PADR.address_id,NULL,PADC.address_line3 ,PADR.address_line3) address_line3
964: FROM per_people_f PPF
965: , per_assignments_f PAF
966: , per_periods_of_service PPS
967: , per_addresses PADR
968: , per_addresses PADC
969: WHERE PAF.person_id = PPF.person_id
970: AND PPS.person_id = PPF.person_id