eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_LA_PROPERTY_TAX_PVT dependencies on OKC_K_HEADERS_B

Line 28: l_chr_id okc_k_headers_b.id%TYPE;

24: l_rulv_rec rulv_rec_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;

Line 41: CURSOR get_est_prop_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS

37:
38: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_EST_PROP_TAX_RULES';
39:
40: -- Start 4042157 fmiao 12/03/04 added update_from_contract --
41: CURSOR get_est_prop_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS
42: SELECT enable_asset_default, property_tax_applicable,
43: bill_property_tax,update_from_contract
44: FROM okl_property_tax_setups
45: WHERE org_id = (SELECT authoring_org_id

Line 46: FROM okc_k_headers_b

42: SELECT enable_asset_default, property_tax_applicable,
43: bill_property_tax,update_from_contract
44: FROM okl_property_tax_setups
45: WHERE org_id = (SELECT authoring_org_id
46: FROM okc_k_headers_b
47: WHERE id = p_chr_id);
48: -- End 4042157 fmiao 12/03/04 added update_from_contract --
49: BEGIN
50:

Line 232: l_chr_id okc_k_headers_b.id%TYPE;

228: l_rulv_rec rulv_rec_type;
229: lx_rgpv_rec rgpv_rec_type;
230: lx_rulv_rec rulv_rec_type;
231:
232: l_chr_id okc_k_headers_b.id%TYPE;
233: l_rgp_id NUMBER;
234: lv_property_tax_applicable okl_property_tax_setups.property_tax_applicable%TYPE;
235: lv_bill_property_tax okl_property_tax_setups.bill_property_tax%TYPE;
236: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_EST_PROP_TAX_RULES';

Line 238: CURSOR get_est_prop_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS

234: lv_property_tax_applicable okl_property_tax_setups.property_tax_applicable%TYPE;
235: lv_bill_property_tax okl_property_tax_setups.bill_property_tax%TYPE;
236: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_EST_PROP_TAX_RULES';
237:
238: CURSOR get_est_prop_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS
239: SELECT property_tax_applicable,
240: bill_property_tax
241: FROM okl_property_tax_setups
242: WHERE org_id = (SELECT authoring_org_id

Line 243: FROM okc_k_headers_b

239: SELECT property_tax_applicable,
240: bill_property_tax
241: FROM okl_property_tax_setups
242: WHERE org_id = (SELECT authoring_org_id
243: FROM okc_k_headers_b
244: WHERE id = p_chr_id);
245:
246: BEGIN
247:

Line 405: CURSOR get_contract_property_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS

401: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE;
402:
403: l_api_name CONSTANT VARCHAR2(30) := 'SYNC_CONTRACT_PROPERTY_TAX';
404:
405: CURSOR get_contract_property_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS
406: SELECT rul.rule_information1, rul.rule_information2, rul.rule_information3
407: FROM OKC_RULES_V rul,
408: OKC_RULE_GROUPS_V rgp
409: WHERE rul.rgp_id = rgp.id

Line 415: CURSOR get_contract_lines(p_chr_id okc_k_headers_b.id%TYPE) IS

411: AND rgp.cle_id is NULL
412: AND rgp.rgd_code = 'LAHDTX'
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

Line 424: CURSOR get_asset_contract_tax_info(p_chr_id okc_k_headers_b.id%TYPE,

420: AND lse.lty_code = 'FREE_FORM1'
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

Line 435: CURSOR get_asset_property_tax_info(p_chr_id okc_k_headers_b.id%TYPE,

431: AND rgp.cle_id = p_cle_id
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