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

Line 2994: from per_periods_of_service service

2990: cursor emp_hire_details
2991: (c_person_id per_all_people_f.person_id%type,
2992: c_basis_end date) is
2993: select fnd_date.date_to_canonical(min(service.date_start))
2994: from per_periods_of_service service
2995: where service.person_id = c_person_id
2996: and service.date_start <= c_basis_end; /*Bug 2668599*/
2997:
2998: /* Bug# 2920732 - Modified the cursor to use secured view per_assignments_f */

Line 3005: per_periods_of_service service

3001: c_basis_start date,
3002: c_basis_end date) is
3003: select fnd_date.date_to_canonical(service.actual_termination_date)
3004: from per_assignments_f assign,
3005: per_periods_of_service service
3006: where service.person_id = c_person_id
3007: and service.period_of_service_id (+)= assign.period_of_service_id
3008: and assign.effective_start_date = (
3009: select max(assign1.effective_start_date)