APPS.OKL_PARTY_PAYMENTS_PVT dependencies on OKL_K_LINES

Line 150: OKL_K_LINES kle,

146: CURSOR lines_csr (p_chr_id IN NUMBER) IS
147: SELECT cle.id,
148: cle.start_date
149: FROM okc_k_lines_v cle,
150: OKL_K_LINES kle,
151: okc_line_styles_b lse
152: WHERE cle.id = kle.id
153: AND lse.id = cle.lse_id
154: AND cle.dnz_chr_id = p_chr_id

Line 1293: OKL_K_LINES kle,

1289: CURSOR line_amount_csr(p_chr_id IN NUMBER) IS
1290: SELECT kle.amount,
1291: kle.id
1292: FROM okc_k_lines_b cle,
1293: OKL_K_LINES kle,
1294: okc_line_styles_b lse
1295: WHERE cle.dnz_chr_id = p_chr_id
1296: AND cle.chr_id = p_chr_id
1297: AND kle.id = cle.id

Line 1301: l_kle_amount OKL_K_LINES.amount%TYPE := 0;

1297: AND kle.id = cle.id
1298: AND cle.lse_id = lse.id
1299: AND lse.lty_code IN ('FEE', 'SOLD_SERVICE');
1300:
1301: l_kle_amount OKL_K_LINES.amount%TYPE := 0;
1302: l_kle_id OKL_K_LINES.id%TYPE;
1303:
1304: CURSOR vendor_amount_csr(p_cle_id IN NUMBER, p_chr_id IN NUMBER) IS
1305: SELECT pyd.disbursement_basis,

Line 1302: l_kle_id OKL_K_LINES.id%TYPE;

1298: AND cle.lse_id = lse.id
1299: AND lse.lty_code IN ('FEE', 'SOLD_SERVICE');
1300:
1301: l_kle_amount OKL_K_LINES.amount%TYPE := 0;
1302: l_kle_id OKL_K_LINES.id%TYPE;
1303:
1304: CURSOR vendor_amount_csr(p_cle_id IN NUMBER, p_chr_id IN NUMBER) IS
1305: SELECT pyd.disbursement_basis,
1306: pyd.disbursement_fixed_amount,

Line 1333: OKL_K_LINES kle,

1329: CURSOR fee_line_amount_csr(p_chr_id IN NUMBER) IS
1330: SELECT kle.amount,
1331: kle.id
1332: FROM okc_k_lines_b cle,
1333: OKL_K_LINES kle,
1334: okc_line_styles_b lse
1335: WHERE cle.dnz_chr_id = p_chr_id
1336: AND cle.chr_id = p_chr_id
1337: AND kle.id = cle.id

Line 1341: l_fee_line_amt OKL_K_LINES.amount%TYPE := 0;

1337: AND kle.id = cle.id
1338: AND cle.lse_id = lse.id
1339: AND lse.lty_code = 'FEE';
1340:
1341: l_fee_line_amt OKL_K_LINES.amount%TYPE := 0;
1342: l_fee_line_id NUMBER;
1343:
1344: CURSOR fee_payment_amt_csr (p_cle_id IN NUMBER, p_chr_id IN NUMBER) IS
1345: SELECT TO_NUMBER(sll.rule_information3) periods,