APPS.PER_ASSIGNMENTS_F1_PKG dependencies on PER_PERIODS_OF_SERVICE
Line 90: FROM per_periods_of_service
86: -- period of service.
87: --
88: CURSOR csr_get_term_dates IS
89: SELECT NVL(final_process_date, p_eot) 90: FROM per_periods_of_service 91: WHERE period_of_service_id = p_pd_os_id
92: UNION
93: SELECT NVL(pdp.final_process_date, p_eot)
94: FROM per_periods_of_placement pdp