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

Line 2186: FROM per_periods_of_service perd,

2182: AND ( ppt.system_person_type IN ('EMP', 'CWK')
2183: OR ( ppt.system_person_type IN ('EX_EMP')
2184: AND EXISTS (
2185: SELECT 1
2186: FROM per_periods_of_service perd,
2187: per_assignments_f assign
2188: WHERE perd.person_id = per.person_id
2189: AND perd.final_process_date >
2190: v_period_start_date

Line 2270: select 1 from per_periods_of_service perd ,per_all_assignments_f assign where perd.person_id =

2266: and usg.effective_end_date >= ppl.effective_end_date
2267: AND (ppt.SYSTEM_PERSON_TYPE in ('EMP' ,'CWK') OR
2268: ( ppt.SYSTEM_PERSON_TYPE in ('EX_EMP' ) and
2269: exists (
2270: select 1 from per_periods_of_service perd ,per_all_assignments_f assign where perd.person_id =
2271: v_person_id
2272: AND perd.final_process_date > v_period_st_dt
2273: AND assign.person_id = ppl.person_id
2274: AND assign.effective_end_date > v_period_st_dt