DBA Data[Home] [Help]

APPS.BEN_TCS_STMT_PROCESS dependencies on PER_PERIODS_OF_SERVICE

Line 2185: FROM per_periods_of_service pps

2181: AND ( ppt.system_person_type IN ('EMP', 'CWK')
2182: OR ( ppt.system_person_type = 'EX_EMP'
2183: AND EXISTS (
2184: SELECT NULL
2185: FROM per_periods_of_service pps
2186: WHERE papf.person_id = pps.person_id
2187: AND pps.date_start <= v_period_end_date --period end date
2188: AND pps.final_process_date >=
2189: v_period_start_date

Line 2276: FROM per_periods_of_service pps

2272: AND ( ppt.system_person_type IN ('EMP', 'CWK')
2273: OR ( ppt.system_person_type = 'EX_EMP'
2274: AND EXISTS (
2275: SELECT NULL
2276: FROM per_periods_of_service pps
2277: WHERE papf.person_id = pps.person_id
2278: AND pps.date_start <= v_period_end_dt --period end date
2279: AND pps.final_process_date >=
2280: v_period_st_dt