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