APPS.OKL_BILL_UPFRONT_TAX_PVT dependencies on OKC_RULE_GROUPS_B

Line 102: FROM okc_rule_groups_b

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
104: AND cle_id IS NULL
105: AND rgd_code = 'LABILL')
106: AND rule_information_category = p_rule_category;

Line 210: FROM okc_rule_groups_b a,

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

Line 552: FROM okc_rule_groups_b rg,

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

Line 564: FROM okc_rule_groups_b rg,

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

Line 593: okc_rule_groups_b rg,

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

Line 636: okc_rule_groups_b rg,

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