DBA Data[Home] [Help]

APPS.PER_ASSIGNMENTS_F1_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 82: FROM per_periods_of_service

78: -- period of service.
79: --
80: CURSOR csr_get_term_dates IS
81: SELECT NVL(final_process_date, p_eot)
82: FROM per_periods_of_service
83: WHERE period_of_service_id = p_pd_os_id
84: UNION
85: SELECT NVL(pdp.final_process_date, p_eot)
86: FROM per_periods_of_placement pdp