DBA Data[Home] [Help]

APPS.OKL_BILL_UPFRONT_TAX_PVT dependencies on OKC_RULE_GROUPS_V

Line 195: FROM okc_rule_groups_v rgp,

191:
192: CURSOR inv_frmt_csr(cp_khr_id IN NUMBER) IS
193: SELECT to_number(rul.rule_information1), -- inf.id, --sechawla 26-may-09 6826580
194: rul.rule_information4 review_invoice_yn
195: FROM okc_rule_groups_v rgp,
196: okc_rules_v rul
197: --, okl_invoice_formats_v inf --sechawla 26-may-09 6826580
198: WHERE rgp.dnz_chr_id = cp_khr_id
199: AND rgp.chr_id = rgp.dnz_chr_id

Line 754: FROM okc_rule_groups_v rgp,

750:
751: CURSOR inv_frmt_csr(cp_khr_id IN NUMBER) IS
752: SELECT to_number(rul.rule_information1), --inf.id, --sechawla 26-may-09 6826580
753: rul.rule_information4 review_invoice_yn
754: FROM okc_rule_groups_v rgp,
755: okc_rules_v rul
756: --, okl_invoice_formats_v inf --sechawla 26-may-09 6826580
757: WHERE rgp.dnz_chr_id = cp_khr_id
758: AND rgp.chr_id = rgp.dnz_chr_id