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_BILL_UPFRONT_TAX_PVT dependencies on OKC_RULES_B

Line 81: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;

77: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
78:
79: l_legal_entity_id okl_trx_ar_invoices_b.legal_entity_id%TYPE;
80:
81: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;
82: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;
83: l_object1_id1 okc_rules_b.object1_id1%TYPE;
84: l_object1_id2 okc_rules_b.object1_id2%TYPE;
85:

Line 82: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;

78:
79: l_legal_entity_id okl_trx_ar_invoices_b.legal_entity_id%TYPE;
80:
81: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;
82: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;
83: l_object1_id1 okc_rules_b.object1_id1%TYPE;
84: l_object1_id2 okc_rules_b.object1_id2%TYPE;
85:
86: CURSOR rule_code_csr(p_khr_id NUMBER, p_rule_category VARCHAR2) IS

Line 83: l_object1_id1 okc_rules_b.object1_id1%TYPE;

79: l_legal_entity_id okl_trx_ar_invoices_b.legal_entity_id%TYPE;
80:
81: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;
82: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;
83: l_object1_id1 okc_rules_b.object1_id1%TYPE;
84: l_object1_id2 okc_rules_b.object1_id2%TYPE;
85:
86: CURSOR rule_code_csr(p_khr_id NUMBER, p_rule_category VARCHAR2) IS
87: SELECT jtot_object1_code,

Line 84: l_object1_id2 okc_rules_b.object1_id2%TYPE;

80:
81: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;
82: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;
83: l_object1_id1 okc_rules_b.object1_id1%TYPE;
84: l_object1_id2 okc_rules_b.object1_id2%TYPE;
85:
86: CURSOR rule_code_csr(p_khr_id NUMBER, p_rule_category VARCHAR2) IS
87: SELECT jtot_object1_code,
88: object1_id1,

Line 90: FROM okc_rules_b

86: CURSOR rule_code_csr(p_khr_id NUMBER, p_rule_category VARCHAR2) IS
87: SELECT jtot_object1_code,
88: object1_id1,
89: object1_id2
90: FROM okc_rules_b
91: WHERE rgp_id =
92: (SELECT id
93: FROM okc_rule_groups_b
94: WHERE dnz_chr_id = p_khr_id

Line 202: okc_rules_b b

198:
199: CURSOR pvt_label_csr(cp_khr_id IN NUMBER) IS
200: SELECT rule_information1 private_label
201: FROM okc_rule_groups_b a,
202: okc_rules_b b
203: WHERE a.dnz_chr_id = cp_khr_id
204: AND a.rgd_code = 'LALABL'
205: AND a.id = b.rgp_id
206: AND b.rule_information_category = 'LALOGO';

Line 208: l_private_label okc_rules_b.rule_information1%TYPE;

204: AND a.rgd_code = 'LALABL'
205: AND a.id = b.rgp_id
206: AND b.rule_information_category = 'LALOGO';
207:
208: l_private_label okc_rules_b.rule_information1%TYPE;
209:
210:
211: begin
212: -- Set API savepoint

Line 544: okc_rules_b rl

540:
541: CURSOR upfront_tax_csr(p_khr_id IN NUMBER) IS
542: SELECT rl.rule_information2
543: FROM okc_rule_groups_b rg,
544: okc_rules_b rl
545: WHERE rg.dnz_chr_id = p_khr_id
546: AND rg.rgd_code = 'LAHDTX'
547: AND rl.rgp_id = rg.id
548: AND rl.dnz_chr_id = rg.dnz_chr_id

Line 556: okc_rules_b r1

552: --akrangan ebtax billing impacts coding start
553: CURSOR l_upfront_tax_treatment_csr(cp_khr_id IN NUMBER) IS
554: SELECT r1.rule_information1 asset_upfront_tax
555: FROM okc_rule_groups_b rg,
556: okc_rules_b r1
557: WHERE rg.dnz_chr_id = cp_khr_id
558: AND rg.rgd_code = 'LAHDTX'
559: AND r1.rgp_id = rg.id
560: AND r1.dnz_chr_id = rg.dnz_chr_id

Line 585: okc_rules_b r1

581: kle_id,
582: org_id
583: FROM okl_tax_sources txs,
584: okc_rule_groups_b rg,
585: okc_rules_b r1
586: WHERE txs.khr_id = cp_khr_id
587: AND txs.application_id = 540
588: AND txs.trx_id = cp_trx_id
589: AND txs.trx_level_type = 'LINE'

Line 628: okc_rules_b r1

624: kle_id,
625: org_id
626: FROM okl_tax_sources txs,
627: okc_rule_groups_b rg,
628: okc_rules_b r1
629: WHERE txs.khr_id = cp_khr_id
630: AND txs.application_id = 540
631: AND txs.trx_id = cp_trx_id
632: AND txs.trx_level_type = 'LINE'