APPS.OKL_LA_SALES_TAX_PVT dependencies on OKC_K_LINES_V

Line 260: l_cle_id okc_k_lines_v.id%TYPE;

256: lx_rgpv_rec rgpv_rec_type;
257: lx_rulv_rec rulv_rec_type;
258:
259: l_chr_id okc_k_headers_b.id%TYPE;
260: l_cle_id okc_k_lines_v.id%TYPE;
261: l_rgp_id NUMBER;
262:
263: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE;
264: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE;

Line 531: ln_cle_id okc_k_lines_v.id%TYPE;

527: IS
528: l_rulv_rec rulv_rec_type;
529: lx_rulv_rec rulv_rec_type;
530:
531: ln_cle_id okc_k_lines_v.id%TYPE;
532:
533: ln_rule_id okc_rules_v.id%TYPE;
534: lv_asset_k_rule_information5 okc_rules_v.rule_information5%TYPE;
535: l_ak_prompt varchar2(100);

Line 563: FROM OKC_K_LINES_V cle,

559: AND rul.rule_information_category = 'LASTCL';
560:
561: CURSOR get_contract_lines(p_chr_id okc_k_headers_b.id%TYPE) IS
562: SELECT cle.id
563: FROM OKC_K_LINES_V cle,
564: OKC_LINE_STYLES_V lse
565: WHERE cle.lse_id = lse.id
566: AND lse.lty_code = 'FREE_FORM1'
567: AND lse.lse_type = 'TLS'

Line 578: p_cle_id okc_k_lines_v.id%TYPE) IS

574: where id = p_chr_id
575: and nvl(orig_system_source_code,'XXX')='OKL_REBOOK';
576:
577: CURSOR get_asset_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE,
578: p_cle_id okc_k_lines_v.id%TYPE) IS
579: SELECT rul.id, rul.rule_information5, cle.ORIG_SYSTEM_ID1
580: FROM OKC_RULES_V rul,
581: OKC_RULE_GROUPS_V rgp,
582: okc_k_lines_b cle

Line 1466: FROM okc_k_lines_v cle,

1462: -- Bug# 6512668: Exclude asset lines in Abandoned status
1463: CURSOR get_asset_csr1 (p_fee_type IN VARCHAR2)
1464: IS
1465: SELECT cle.id, cle.name, cle.item_description
1466: FROM okc_k_lines_v cle,
1467: okc_rule_groups_b rg1,
1468: okc_rules_b rl1,
1469: okc_line_styles_b lse,
1470: okc_rule_groups_b rg2,

Line 1498: FROM okc_k_lines_v cle,

1494: -- Bug# 6512668: Exclude asset lines in Abandoned status
1495: CURSOR get_asset_csr2 (p_fee_type IN VARCHAR2)
1496: IS
1497: SELECT cle.id, cle.name, cle.item_description
1498: FROM okc_k_lines_v cle,
1499: okc_rule_groups_b rg1,
1500: okc_rules_b rl1,
1501: okc_line_styles_b lse
1502: WHERE cle.dnz_chr_id = p_contract_id

Line 2360: FROM okc_k_lines_v cle,

2356: -- Bug# 6512668: Exclude asset lines in Abandoned status
2357: CURSOR get_asset_csr1 (p_fee_type IN VARCHAR2)
2358: IS
2359: SELECT cle.id, cle.name, cle.item_description
2360: FROM okc_k_lines_v cle,
2361: okc_rule_groups_b rg1,
2362: okc_rules_b rl1,
2363: okc_line_styles_b lse,
2364: okc_rule_groups_b rg2,

Line 2393: FROM okc_k_lines_v cle,

2389: -- Bug# 6512668: Exclude asset lines in Abandoned status
2390: CURSOR get_asset_csr2 (p_fee_type IN VARCHAR2)
2391: IS
2392: SELECT cle.id, cle.name, cle.item_description
2393: FROM okc_k_lines_v cle,
2394: okc_rule_groups_b rg1,
2395: okc_rules_b rl1,
2396: okc_line_styles_b lse
2397: WHERE cle.dnz_chr_ID = p_contract_id

Line 5780: FROM okc_k_lines_v cle,

5776:
5777: CURSOR l_asset_csr IS
5778: SELECT cle.id,
5779: name
5780: FROM okc_k_lines_v cle,
5781: okc_line_styles_b sty,
5782: okc_statuses_b sts
5783: WHERE cle.lse_id = sty.id
5784: AND cle.dnz_chr_id = p_chr_id

Line 6474: FROM okc_k_lines_v clev,

6470: SELECT kle.id,
6471: kle.amount,
6472: clev.name,
6473: lsev.name line_type
6474: FROM okc_k_lines_v clev,
6475: okl_k_lines kle,
6476: okc_statuses_b okcsts,
6477: okc_line_styles_v lsev
6478: WHERE clev.dnz_chr_id = p_chr_id