DBA Data[Home] [Help]

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,