APPS.AP_WEB_EXPORT_ER dependencies on PER_PERIODS_OF_SERVICE_V

Line 2336: FROM per_periods_of_service_v

2332: BEGIN
2333:
2334: SELECT 'Y'
2335: INTO l_is_active_employee
2336: FROM per_periods_of_service_v
2337: WHERE person_id = l_invoice_rec.employee_id
2338: AND trunc(sysdate) <= trunc(nvl(final_process_date, sysdate))
2339: AND ROWNUM=1
2340: ORDER BY LAST_UPDATE_DATE DESC;