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

Line 389: from per_periods_of_service

385: and paaf.effective_end_date
386: and p_end_date between papf.effective_start_date
387: and papf.effective_end_date
388: and not exists (select actual_termination_date
389: from per_periods_of_service
390: where actual_termination_date =
391: paaf.effective_end_date
392: and person_id = papf.person_id
393: and actual_termination_date = nvl(final_process_date,actual_termination_date )

Line 460: from per_periods_of_service

456: --and past.PER_SYSTEM_STATUS = 'TERM_ASSIGN'
457: and (( papf.effective_end_date <= p_end_date
458: --and paaf.effective_end_date between p_start_date and p_end_date
459: and exists (select actual_termination_date
460: from per_periods_of_service
461: where actual_termination_date =
462: paaf.effective_end_date
463: and person_id = papf.person_id
464: and actual_termination_date = nvl(final_process_date,actual_termination_date )))