APPS.OKL_INTERNAL_BILLING_PVT dependencies on OKL_INVOICE_FORMATS_V

Line 410: --, okl_invoice_formats_v inf --sechawla 26-may-09 6826580

406: SELECT to_number(rul.rule_information1), --inf.id, --sechawla 26-may-09 6826580
407: rul.rule_information4 review_invoice_yn
408: FROM okc_rule_groups_v rgp,
409: okc_rules_v rul
410: --, okl_invoice_formats_v inf --sechawla 26-may-09 6826580
411: WHERE rgp.dnz_chr_id = cp_khr_id
412: AND rgp.chr_id = rgp.dnz_chr_id
413: AND rgp.id = rul.rgp_id
414: AND rgp.cle_id IS NULL

Line 419: l_inf_id okl_invoice_formats_v.id%TYPE;

415: AND rgp.rgd_code = 'LABILL'
416: AND rul.rule_information_category = 'LAINVD';
417: -- AND rul.rule_information1 = inf.name; --sechawla 26-may-09 6826580
418:
419: l_inf_id okl_invoice_formats_v.id%TYPE;
420:
421: -- -------------------------------------------
422: -- To support private label transfers to
423: -- AR. Bug 4525643

Line 3305: FROM okl_invoice_formats_v inf,

3301: -- correctly
3302: CURSOR inv_format_default_csr ( p_format_id IN NUMBER ) IS
3303: SELECT ity.name ity_name,
3304: ilt.name ilt_name
3305: FROM okl_invoice_formats_v inf,
3306: okl_invoice_types_v ity,
3307: okl_invc_line_types_v ilt
3308: WHERE inf.id = p_format_id
3309: AND ity.inf_id = inf.id