APPS.OKL_LA_PAYMENTS_PVT dependencies on OKC_STATUSES_V

Line 2003: FROM OKC_STATUSES_V OKCS, OKC_K_LINES_B CLE

1999:
2000:
2001: CURSOR INVALID_LINE_CSR(P_CLE_ID IN NUMBER) is
2002: SELECT 'Y'
2003: FROM OKC_STATUSES_V OKCS, OKC_K_LINES_B CLE
2004: WHERE CLE.STS_CODE = OKCS.CODE
2005: -- AND OKCS.STE_CODE IN ('EXPIRED','HOLD','CANCELLED','TERMINATED')
2006: AND OKCS.STE_CODE IN ('TERMINATED')
2007: AND CLE.ID = P_CLE_ID;

Line 2013: okc_statuses_v sts,

2009: CURSOR GET_FEE_TYPE_SUB_CSR(P_CHR_ID IN NUMBER, p_service_fee_id IN NUMBER) is
2010: SELECT fee_line.fee_type
2011: FROM okl_k_lines_full_v l,
2012: okc_line_styles_v sty,
2013: okc_statuses_v sts,
2014: okl_k_lines fee_line
2015: WHERE l.lse_id = sty.id
2016: AND l.sts_code = sts.code
2017: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')