APPS.OKL_UBB_INTEGRATION_PVT dependencies on OKC_STATUSES_V
Line 78: FROM okc_statuses_v okcsts
74: AND line.cle_id = p_usage_line_id
75: -- added to handle abandon line
76: AND NOT EXISTS (
77: SELECT 'Y' 78: FROM okc_statuses_v okcsts 79: WHERE okcsts.code = line.sts_code
80: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
81:
82: CURSOR ib_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,