APPS.OKL_LA_PAYMENTS_PVT dependencies on OKC_STATUSES_V

Line 2214: FROM OKC_STATUSES_V OKCS, OKC_K_LINES_B CLE

2210:
2211:
2212: CURSOR INVALID_LINE_CSR(P_CLE_ID IN NUMBER) is
2213: SELECT 'Y'
2214: FROM OKC_STATUSES_V OKCS, OKC_K_LINES_B CLE
2215: WHERE CLE.STS_CODE = OKCS.CODE
2216: -- AND OKCS.STE_CODE IN ('EXPIRED','HOLD','CANCELLED','TERMINATED')
2217: AND OKCS.STE_CODE IN ('TERMINATED')
2218: AND CLE.ID = P_CLE_ID;

Line 2224: okc_statuses_v sts,

2220: CURSOR GET_FEE_TYPE_SUB_CSR(P_CHR_ID IN NUMBER, p_service_fee_id IN NUMBER) is
2221: SELECT fee_line.fee_type
2222: FROM okl_k_lines_full_v l,
2223: okc_line_styles_v sty,
2224: okc_statuses_v sts,
2225: okl_k_lines fee_line
2226: WHERE l.lse_id = sty.id
2227: AND l.sts_code = sts.code
2228: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')