APPS.OKL_LA_PROPERTY_TAX_PVT dependencies on OKC_K_LINES_V

Line 29: l_cle_id okc_k_lines_v.id%TYPE;

25: lx_rgpv_rec rgpv_rec_type;
26: lx_rulv_rec rulv_rec_type;
27:
28: l_chr_id okc_k_headers_b.id%TYPE;
29: l_cle_id okc_k_lines_v.id%TYPE;
30: l_rgp_id NUMBER;
31: lv_enable_asset_default okl_property_tax_setups.enable_asset_default%TYPE;
32: lv_property_tax_applicable okl_property_tax_setups.property_tax_applicable%TYPE;
33: lv_bill_property_tax okl_property_tax_setups.bill_property_tax%TYPE;

Line 394: ln_cle_id okc_k_lines_v.id%TYPE;

390: IS
391: l_rulv_rec rulv_rec_type;
392: lx_rulv_rec rulv_rec_type;
393:
394: ln_cle_id okc_k_lines_v.id%TYPE;
395:
396: ln_rule_id okc_rules_v.id%TYPE;
397: lv_asset_k_rule_information1 okc_rules_v.rule_information1%TYPE;
398:

Line 417: FROM OKC_K_LINES_V cle,

413: AND rul.rule_information_category = 'LAPRTX';
414:
415: CURSOR get_contract_lines(p_chr_id okc_k_headers_b.id%TYPE) IS
416: SELECT cle.id
417: FROM OKC_K_LINES_V cle,
418: OKC_LINE_STYLES_V lse
419: WHERE cle.lse_id = lse.id
420: AND lse.lty_code = 'FREE_FORM1'
421: AND lse.lse_type = 'TLS'

Line 425: p_cle_id okc_k_lines_v.id%TYPE) IS

421: AND lse.lse_type = 'TLS'
422: AND cle.dnz_chr_id = p_chr_id;
423:
424: CURSOR get_asset_contract_tax_info(p_chr_id okc_k_headers_b.id%TYPE,
425: p_cle_id okc_k_lines_v.id%TYPE) IS
426: SELECT rul.rule_information1
427: FROM OKC_RULES_V rul,
428: OKC_RULE_GROUPS_V rgp
429: WHERE rul.rgp_id = rgp.id

Line 436: p_cle_id okc_k_lines_v.id%TYPE) IS

432: AND rgp.rgd_code = 'LAASTX'
433: AND rul.rule_information_category = 'LAASTK';
434:
435: CURSOR get_asset_property_tax_info(p_chr_id okc_k_headers_b.id%TYPE,
436: p_cle_id okc_k_lines_v.id%TYPE) IS
437: SELECT rul.id
438: FROM OKC_RULES_V rul,
439: OKC_RULE_GROUPS_V rgp
440: WHERE rul.rgp_id = rgp.id