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

Line 367: from per_periods_of_service

363: and paaf.effective_end_date
364: and p_end_date between papf.effective_start_date
365: and papf.effective_end_date
366: and not exists (select actual_termination_date
367: from per_periods_of_service
368: where actual_termination_date =
369: paaf.effective_end_date
370: and person_id = papf.person_id
371: and actual_termination_date = nvl(final_process_date,actual_termination_date )

Line 443: from per_periods_of_service

439: and ( ( papf.effective_end_date between p_start_date
440: and p_end_date
441: --and paaf.effective_end_date between p_start_date and p_end_date
442: and exists (select actual_termination_date
443: from per_periods_of_service
444: where actual_termination_date =
445: paaf.effective_end_date
446: and person_id = papf.person_id
447: and actual_termination_date = nvl(final_process_date,actual_termination_date ))