DBA Data[Home] [Help]

APPS.PAYVWELE dependencies on PER_PERIODS_OF_SERVICE

Line 170: FROM per_periods_of_service pps

166: p_session_date IN DATE) RETURN DATE IS
167:
168: CURSOR get_fpd_or_atd IS
169: SELECT pps.final_process_date
170: FROM per_periods_of_service pps
171: WHERE date_start <= p_session_date
172: AND pps.period_of_service_id = (
173: SELECT DISTINCT(period_of_service_id)
174: FROM per_all_assignments_f