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 90: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;

86: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
87:
88: l_legal_entity_id okl_trx_ar_invoices_b.legal_entity_id%TYPE;
89:
90: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;
91: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;
92: l_object1_id1 okc_rules_b.object1_id1%TYPE;
93: l_object1_id2 okc_rules_b.object1_id2%TYPE;
94:

Line 91: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;

87:
88: l_legal_entity_id okl_trx_ar_invoices_b.legal_entity_id%TYPE;
89:
90: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;
91: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;
92: l_object1_id1 okc_rules_b.object1_id1%TYPE;
93: l_object1_id2 okc_rules_b.object1_id2%TYPE;
94:
95: CURSOR rule_code_csr(p_khr_id NUMBER, p_rule_category VARCHAR2) IS

Line 92: l_object1_id1 okc_rules_b.object1_id1%TYPE;

88: l_legal_entity_id okl_trx_ar_invoices_b.legal_entity_id%TYPE;
89:
90: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;
91: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;
92: l_object1_id1 okc_rules_b.object1_id1%TYPE;
93: l_object1_id2 okc_rules_b.object1_id2%TYPE;
94:
95: CURSOR rule_code_csr(p_khr_id NUMBER, p_rule_category VARCHAR2) IS
96: SELECT jtot_object1_code,

Line 93: l_object1_id2 okc_rules_b.object1_id2%TYPE;

89:
90: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;
91: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;
92: l_object1_id1 okc_rules_b.object1_id1%TYPE;
93: l_object1_id2 okc_rules_b.object1_id2%TYPE;
94:
95: CURSOR rule_code_csr(p_khr_id NUMBER, p_rule_category VARCHAR2) IS
96: SELECT jtot_object1_code,
97: object1_id1,

Line 99: FROM okc_rules_b

95: CURSOR rule_code_csr(p_khr_id NUMBER, p_rule_category VARCHAR2) IS
96: SELECT jtot_object1_code,
97: object1_id1,
98: object1_id2
99: FROM okc_rules_b
100: WHERE rgp_id =
101: (SELECT id
102: FROM okc_rule_groups_b
103: WHERE dnz_chr_id = p_khr_id

Line 211: okc_rules_b b

207:
208: CURSOR pvt_label_csr(cp_khr_id IN NUMBER) IS
209: SELECT rule_information1 private_label
210: FROM okc_rule_groups_b a,
211: okc_rules_b b
212: WHERE a.dnz_chr_id = cp_khr_id
213: AND a.rgd_code = 'LALABL'
214: AND a.id = b.rgp_id
215: AND b.rule_information_category = 'LALOGO';

Line 217: l_private_label okc_rules_b.rule_information1%TYPE;

213: AND a.rgd_code = 'LALABL'
214: AND a.id = b.rgp_id
215: AND b.rule_information_category = 'LALOGO';
216:
217: l_private_label okc_rules_b.rule_information1%TYPE;
218:
219:
220: begin
221: -- Set API savepoint

Line 553: okc_rules_b rl

549:
550: CURSOR upfront_tax_csr(p_khr_id IN NUMBER) IS
551: SELECT rl.rule_information2
552: FROM okc_rule_groups_b rg,
553: okc_rules_b rl
554: WHERE rg.dnz_chr_id = p_khr_id
555: AND rg.rgd_code = 'LAHDTX'
556: AND rl.rgp_id = rg.id
557: AND rl.dnz_chr_id = rg.dnz_chr_id

Line 565: okc_rules_b r1

561: --akrangan ebtax billing impacts coding start
562: CURSOR l_upfront_tax_treatment_csr(cp_khr_id IN NUMBER) IS
563: SELECT r1.rule_information1 asset_upfront_tax
564: FROM okc_rule_groups_b rg,
565: okc_rules_b r1
566: WHERE rg.dnz_chr_id = cp_khr_id
567: AND rg.rgd_code = 'LAHDTX'
568: AND r1.rgp_id = rg.id
569: AND r1.dnz_chr_id = rg.dnz_chr_id

Line 594: okc_rules_b r1

590: kle_id,
591: org_id
592: FROM okl_tax_sources txs,
593: okc_rule_groups_b rg,
594: okc_rules_b r1
595: WHERE txs.khr_id = cp_khr_id
596: AND txs.application_id = 540
597: AND txs.trx_id = cp_trx_id
598: AND txs.trx_level_type = 'LINE'

Line 637: okc_rules_b r1

633: kle_id,
634: org_id
635: FROM okl_tax_sources txs,
636: okc_rule_groups_b rg,
637: okc_rules_b r1
638: WHERE txs.khr_id = cp_khr_id
639: AND txs.application_id = 540
640: AND txs.trx_id = cp_trx_id
641: AND txs.trx_level_type = 'LINE'