APPS.OKL_REVERSE_CONTRACT_PVT dependencies on OKC_STATUSES_V

Line 734: FROM okc_statuses_v okcsts

730: AND KLE.FEE_TYPE = 'ROLLOVER'
731: AND KLE.ID = CLEB.ID
732: AND NOT EXISTS (
733: SELECT 'Y'
734: FROM okc_statuses_v okcsts
735: WHERE okcsts.code = cleb.sts_code
736: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
737:
738: -- Cursor to select contract number