APPS.OKL_BILL_UPFRONT_TAX_PVT dependencies on OKL_INVOICE_FORMATS_V

Line 188: okl_invoice_formats_v inf

184: SELECT inf.id,
185: rul.rule_information4 review_invoice_yn
186: FROM okc_rule_groups_v rgp,
187: okc_rules_v rul,
188: okl_invoice_formats_v inf
189: WHERE rgp.dnz_chr_id = cp_khr_id
190: AND rgp.chr_id = rgp.dnz_chr_id
191: AND rgp.id = rul.rgp_id
192: AND rgp.cle_id IS NULL

Line 197: l_inf_id okl_invoice_formats_v.id%TYPE;

193: AND rgp.rgd_code = 'LABILL'
194: AND rul.rule_information_category = 'LAINVD'
195: AND rul.rule_information1 = inf.name;
196:
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,