APPS.OKL_PARTY_PAYMENTS_PVT dependencies on OKC_K_LINES_B

Line 1292: FROM okc_k_lines_b cle,

1288:
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

Line 1323: FROM okc_line_styles_b lse, okc_k_lines_b cle, OKL_PARTY_PAYMENT_HDR pph

1319: l_chr_id NUMBER;
1320:
1321: CURSOR line_type_csr(p_chr_id IN NUMBER) IS
1322: SELECT DISTINCT(pph.cle_id),pph.payout_basis,lse.lty_code
1323: FROM okc_line_styles_b lse, okc_k_lines_b cle, OKL_PARTY_PAYMENT_HDR pph
1324: WHERE lse.id = cle.lse_id
1325: AND lse.lty_code = 'FEE'
1326: AND cle.id= pph.cle_id
1327: AND pph.dnz_chr_id =p_chr_id;

Line 1332: FROM okc_k_lines_b cle,

1328:
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

Line 1363: FROM okc_line_styles_b lse, okc_k_lines_b cle, OKL_PARTY_PAYMENT_HDR pph

1359: l_payment_amt NUMBER := 0;
1360:
1361: CURSOR s_line_type_csr(p_chr_id IN NUMBER) IS
1362: SELECT DISTINCT(pph.cle_id),pph.payout_basis
1363: FROM okc_line_styles_b lse, okc_k_lines_b cle, OKL_PARTY_PAYMENT_HDR pph
1364: WHERE lse.id = cle.lse_id
1365: AND lse.lty_code = 'SOLD_SERVICE'
1366: AND cle.id= pph.cle_id
1367: AND pph.dnz_chr_id =p_chr_id;