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_RULES_V

Line 396: ln_rule_id okc_rules_v.id%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:
399: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE;
400: lv_k_rule_information2 okc_rules_v.rule_information2%TYPE;

Line 397: lv_asset_k_rule_information1 okc_rules_v.rule_information1%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:
399: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE;
400: lv_k_rule_information2 okc_rules_v.rule_information2%TYPE;
401: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE;

Line 399: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE;

395:
396: ln_rule_id okc_rules_v.id%TYPE;
397: lv_asset_k_rule_information1 okc_rules_v.rule_information1%TYPE;
398:
399: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE;
400: lv_k_rule_information2 okc_rules_v.rule_information2%TYPE;
401: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE;
402:
403: l_api_name CONSTANT VARCHAR2(30) := 'SYNC_CONTRACT_PROPERTY_TAX';

Line 400: lv_k_rule_information2 okc_rules_v.rule_information2%TYPE;

396: ln_rule_id okc_rules_v.id%TYPE;
397: lv_asset_k_rule_information1 okc_rules_v.rule_information1%TYPE;
398:
399: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE;
400: lv_k_rule_information2 okc_rules_v.rule_information2%TYPE;
401: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE;
402:
403: l_api_name CONSTANT VARCHAR2(30) := 'SYNC_CONTRACT_PROPERTY_TAX';
404:

Line 401: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE;

397: lv_asset_k_rule_information1 okc_rules_v.rule_information1%TYPE;
398:
399: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE;
400: lv_k_rule_information2 okc_rules_v.rule_information2%TYPE;
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

Line 407: FROM OKC_RULES_V rul,

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
410: AND rgp.dnz_chr_id = p_chr_id
411: AND rgp.cle_id is NULL

Line 427: FROM OKC_RULES_V rul,

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

Line 438: FROM OKC_RULES_V rul,

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
441: AND rgp.dnz_chr_id = p_chr_id
442: AND rgp.cle_id = p_cle_id