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_ES_COMP_CERT_ARCHIVE_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 173: ,per_periods_of_service ppos

169: ,c_end_date DATE
170: ,c_business_group_id NUMBER) IS
171: SELECT assignment_id
172: FROM per_all_assignments_f asl
173: ,per_periods_of_service ppos
174: ,hr_soft_coding_keyflex hr
175: ,hr_organization_information hoi
176: WHERE asl.person_id BETWEEN stperson AND endperson
177: AND asl.primary_flag = 'Y'

Line 474: ,per_periods_of_service pps

470: ,fnd_date.canonical_to_date(pps.pds_information9) vacation_from
471: ,fnd_date.canonical_to_date(pps.pds_information10) vacation_to
472: FROM per_all_people_f pap
473: ,per_all_assignments_f paa
474: ,per_periods_of_service pps
475: ,pay_assignment_actions paas
476: ,pay_payroll_actions ppa
477: ,hr_soft_coding_keyflex hr
478: ,hr_organization_information hoi

Line 524: ,per_periods_of_service pps

520: FROM per_all_people_f pap
521: ,per_all_assignments_f paa
522: ,pay_assignment_actions paas
523: ,pay_payroll_actions ppa
524: ,per_periods_of_service pps
525: ,hr_soft_coding_keyflex hr
526: ,hr_organization_information hoi
527: ,per_absence_attendance_types pat
528: ,per_absence_attendances paat