APPS.OKL_LA_SALES_TAX_PVT dependencies on OKC_K_LINES_V

Line 418: l_cle_id okc_k_lines_v.id%TYPE;

414: lx_rgpv_rec rgpv_rec_type;
415: lx_rulv_rec rulv_rec_type;
416:
417: l_chr_id okc_k_headers_b.id%TYPE;
418: l_cle_id okc_k_lines_v.id%TYPE;
419: l_rgp_id NUMBER;
420:
421: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE;
422: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE;

Line 689: ln_cle_id okc_k_lines_v.id%TYPE;

685: IS
686: l_rulv_rec rulv_rec_type;
687: lx_rulv_rec rulv_rec_type;
688:
689: ln_cle_id okc_k_lines_v.id%TYPE;
690:
691: ln_rule_id okc_rules_v.id%TYPE;
692: lv_asset_k_rule_information5 okc_rules_v.rule_information5%TYPE;
693: l_ak_prompt varchar2(100);

Line 721: FROM OKC_K_LINES_V cle,

717: AND rul.rule_information_category = 'LASTCL';
718:
719: CURSOR get_contract_lines(p_chr_id okc_k_headers_b.id%TYPE) IS
720: SELECT cle.id
721: FROM OKC_K_LINES_V cle,
722: OKC_LINE_STYLES_V lse
723: WHERE cle.lse_id = lse.id
724: AND lse.lty_code = 'FREE_FORM1'
725: AND lse.lse_type = 'TLS'

Line 736: p_cle_id okc_k_lines_v.id%TYPE) IS

732: where id = p_chr_id
733: and nvl(orig_system_source_code,'XXX')='OKL_REBOOK';
734:
735: CURSOR get_asset_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE,
736: p_cle_id okc_k_lines_v.id%TYPE) IS
737: SELECT rul.id, rul.rule_information5, cle.ORIG_SYSTEM_ID1
738: FROM OKC_RULES_V rul,
739: OKC_RULE_GROUPS_V rgp,
740: okc_k_lines_b cle

Line 1652: FROM okc_k_lines_v cle,

1648: -- Bug# 6512668: Exclude asset lines in Abandoned status
1649: CURSOR get_asset_csr1 (p_fee_type IN VARCHAR2)
1650: IS
1651: SELECT cle.id, cle.name, cle.item_description
1652: FROM okc_k_lines_v cle,
1653: okc_rule_groups_b rg1,
1654: okc_rules_b rl1,
1655: okc_line_styles_b lse,
1656: okc_rule_groups_b rg2,

Line 1684: FROM okc_k_lines_v cle,

1680: -- Bug# 6512668: Exclude asset lines in Abandoned status
1681: CURSOR get_asset_csr2 (p_fee_type IN VARCHAR2)
1682: IS
1683: SELECT cle.id, cle.name, cle.item_description
1684: FROM okc_k_lines_v cle,
1685: okc_rule_groups_b rg1,
1686: okc_rules_b rl1,
1687: okc_line_styles_b lse
1688: WHERE cle.dnz_chr_id = p_contract_id

Line 2564: FROM okc_k_lines_v cle,

2560: -- Bug# 6512668: Exclude asset lines in Abandoned status
2561: CURSOR get_asset_csr1 (p_fee_type IN VARCHAR2)
2562: IS
2563: SELECT cle.id, cle.name, cle.item_description
2564: FROM okc_k_lines_v cle,
2565: okc_rule_groups_b rg1,
2566: okc_rules_b rl1,
2567: okc_line_styles_b lse,
2568: okc_rule_groups_b rg2,

Line 2597: FROM okc_k_lines_v cle,

2593: -- Bug# 6512668: Exclude asset lines in Abandoned status
2594: CURSOR get_asset_csr2 (p_fee_type IN VARCHAR2)
2595: IS
2596: SELECT cle.id, cle.name, cle.item_description
2597: FROM okc_k_lines_v cle,
2598: okc_rule_groups_b rg1,
2599: okc_rules_b rl1,
2600: okc_line_styles_b lse
2601: WHERE cle.dnz_chr_ID = p_contract_id

Line 6176: FROM okc_k_lines_v cle,

6172:
6173: CURSOR l_asset_csr IS
6174: SELECT cle.id,
6175: name
6176: FROM okc_k_lines_v cle,
6177: okc_line_styles_b sty,
6178: okc_statuses_b sts
6179: WHERE cle.lse_id = sty.id
6180: AND cle.dnz_chr_id = p_chr_id

Line 6288: CURSOR l_chk_rel_line_csr (p_kle_id IN OKC_K_LINES_V.ID%TYPE) IS

6284: l_new_asset_cnt NUMBER :=0;
6285:
6286: -- New cursor to check if the asset is a released asset
6287: -- at the asset line level.
6288: CURSOR l_chk_rel_line_csr (p_kle_id IN OKC_K_LINES_V.ID%TYPE) IS
6289: SELECT NVL(kle_top.re_lease_yn,'N') release_flag
6290: FROM okl_k_lines kle_top
6291: WHERE kle_top.id = p_kle_id;
6292: -- Bug# 15992711 : End of Modifications

Line 7020: FROM okc_k_lines_v clev,

7016: clev.name,
7017: lsev.name line_type,
7018: --Bug# 12807203
7019: kle.fee_type
7020: FROM okc_k_lines_v clev,
7021: okl_k_lines kle,
7022: okc_statuses_b okcsts,
7023: okc_line_styles_v lsev
7024: WHERE clev.dnz_chr_id = p_chr_id