APPS.OKL_LA_PAYMENTS_PVT dependencies on OKL_K_LINES

Line 64: FROM okl_k_lines kle

60: RETURN VARCHAR2 IS
61:
62: CURSOR l_fee_csr(p_cle_id IN NUMBER) IS
63: SELECT kle.fee_purpose_code
64: FROM okl_k_lines kle
65: WHERE kle.id = p_cle_id;
66:
67: l_fee_rec l_fee_csr%ROWTYPE;
68:

Line 480: FROM okl_k_lines cle

476: CURSOR c_is_capitalize (p_asset_id number)
477: IS
478: SELECT NVL(cle.CAPITALIZE_DOWN_PAYMENT_YN,'N') CAPITALIZE_DOWN_PAYMENT_YN,
479: cle.DOWN_PAYMENT_RECEIVER_CODE
480: FROM okl_k_lines cle
481: WHERE cle.id = p_asset_id
482: ;
483:
484: BEGIN

Line 553: OKC_RULE_GROUPS_V RG, OKL_K_LINES_V LN, OKC_LINE_STYLES_V LS

549: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE := null;
550: cursor LINE_STYLE_CSR(P_RGP_ID IN NUMBER) is
551: SELECT LS.LTY_CODE
552: FROM
553: OKC_RULE_GROUPS_V RG, OKL_K_LINES_V LN, OKC_LINE_STYLES_V LS
554: WHERE
555: RG.ID = P_RGP_ID AND
556: RG.CLE_ID = LN.ID AND
557: LN.ID = LS.ID;

Line 730: SELECT FEE_TYPE FROM okc_k_lines_b CLEB, okl_k_lines KLE

726: OKC_K_LINES_B.ID%TYPE) RETURN BOOLEAN IS
727:
728: l_fee_type VARCHAR2(150) := NULL;
729: CURSOR fee_type_csr(P_ID IN OKC_K_LINES_B.ID%TYPE) IS
730: SELECT FEE_TYPE FROM okc_k_lines_b CLEB, okl_k_lines KLE
731: WHERE KLE.ID = P_ID
732: AND KLE.ID = CLEB.ID;
733:
734: BEGIN

Line 764: SELECT FEE_TYPE FROM okl_k_lines KLE

760: OKC_K_LINES_B.ID%TYPE) RETURN BOOLEAN IS
761:
762: l_fee_type VARCHAR2(150) := NULL;
763: CURSOR fee_type_csr(P_ID IN OKC_K_LINES_B.ID%TYPE) IS
764: SELECT FEE_TYPE FROM okl_k_lines KLE
765: WHERE KLE.ID = P_ID;
766:
767: BEGIN
768: IF (p_service_or_fee_id IS NULL OR p_service_or_fee_id = '') THEN

Line 2065: okl_k_lines kleb,

2061: WHERE ID = p_chr_id ;
2062: CURSOR fee_line_amount_csr(p_rgp_id IN NUMBER) is
2063: SELECT kleb.amount amount
2064: FROM okc_k_lines_b cleb,
2065: okl_k_lines kleb,
2066: okc_line_styles_b lseb,
2067: okc_k_headers_b chrb,
2068: okc_rule_groups_b rg
2069: WHERE chrb.id = cleb.dnz_chr_id

Line 2200: okl_k_lines kleb,

2196: --Changed query for performance --dkagrawa
2197: CURSOR FEE_LINE_CSR(P_RGP_ID IN NUMBER) is
2198: SELECT kleb.fee_type fee_type
2199: FROM okc_k_lines_b cleb,
2200: okl_k_lines kleb,
2201: okc_line_styles_b lseb,
2202: okc_k_headers_b chrb,
2203: okc_rule_groups_b rg
2204: WHERE chrb.id = cleb.dnz_chr_id

Line 2222: FROM okl_k_lines_full_v l,

2218: AND CLE.ID = P_CLE_ID;
2219: -- added for bug 5115701 - start
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

Line 2225: okl_k_lines fee_line

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')
2229: AND sty.lty_code = 'LINK_FEE_ASSET'

Line 2234: l_subline_fee_type okl_k_lines.fee_type%type;

2230: AND l.dnz_chr_id = P_CHR_ID
2231: AND l.cle_id = fee_line.id
2232: and fee_line.id = p_service_fee_id;
2233:
2234: l_subline_fee_type okl_k_lines.fee_type%type;
2235: -- added for bug 5115701 - end
2236: l_invalid_line varchar2(1) := 'N';
2237:
2238: l_chr_rec CHR_DTLS_CSR%ROWTYPE;