APPS.OKL_BILL_UPFRONT_TAX_PVT dependencies on OKC_RULE_GROUPS_B

Line 93: FROM okc_rule_groups_b

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
95: AND cle_id IS NULL
96: AND rgd_code = 'LABILL')
97: AND rule_information_category = p_rule_category;

Line 201: FROM okc_rule_groups_b a,

197: l_inf_id okl_invoice_formats_v.id%TYPE;
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

Line 543: FROM okc_rule_groups_b rg,

539: xp_bpd_acc_rec Okl_Acc_Call_Pub.bpd_acc_rec_type;
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

Line 555: FROM okc_rule_groups_b rg,

551: upfront_tax_rec upfront_tax_csr%ROWTYPE;
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

Line 584: okc_rule_groups_b rg,

580: trx_level_type,
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

Line 627: okc_rule_groups_b rg,

623: trx_level_type,
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