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

Line 243: from per_all_people_f PER, per_periods_of_service PPS

239:
240: CURSOR csr_start_date
241: IS
242: select DECODE(PER.CURRENT_EMPLOYEE_FLAG,'Y',PPS.DATE_START,NULL)
243: from per_all_people_f PER, per_periods_of_service PPS
244: where per.person_id = g_person_id
245: and pps.person_id = g_person_id
246: and rownum=1
247: order by per.effective_start_date;

Line 503: From per_all_assignments_f asg, per_periods_of_service per

499: --For bug 7229852: Added new cursor
500: CURSOR csr_get_atd
501: IS
502: Select actual_termination_date
503: From per_all_assignments_f asg, per_periods_of_service per
504: Where asg.assignment_id = p_assignment_id
505: And per.period_of_service_id = asg.period_of_service_id
506: AND p_effective_date between asg.effective_start_date and asg.effective_end_date;
507: