DBA Data[Home] [Help]

APPS.OKL_BILL_UPFRONT_TAX_PVT dependencies on OKC_RULES_V

Line 196: okc_rules_v rul

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
200: AND rgp.id = rul.rgp_id

Line 755: okc_rules_v rul

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
759: AND rgp.id = rul.rgp_id