APPS.OKL_ARINTF_PVT dependencies on OKL_INVOICE_FORMATS_V

Line 466: FROM okl_invoice_formats_v inf,

462: SELECT inf.contract_level_yn, -- Multi-contract Y/N
463: ity.group_by_contract_yn, -- Provide Contract Details
464: ity.group_asset_yn, -- Combine Assets
465: inf.name -- invoice group
466: FROM okl_invoice_formats_v inf,
467: okl_invoice_types_v ity,
468: okl_invc_line_types_v ilt,
469: okl_invc_frmt_strms_v frs,
470: okl_strm_type_v sty

Line 485: FROM okl_invoice_formats_v inf,

481: SELECT inf.contract_level_yn, -- Multi-contract Y/N
482: ity.group_by_contract_yn, -- Provide Contract Details
483: ity.group_asset_yn, -- Combine Assets
484: inf.name -- invoice group
485: FROM okl_invoice_formats_v inf,
486: okl_invoice_types_v ity,
487: okl_invc_line_types_v ilt
488: WHERE inf.id = p_format_id
489: AND ity.inf_id = inf.id

Line 1910: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;

1906:
1907: --start: | 15-FEB-07 cklee R12 Billing enhancement project
1908: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;
1909: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;
1910: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;
1911: l_invoice_group okl_invoice_formats_v.name%type;
1912: l_khr_id okc_k_headers_b.id%type;
1913: l_bank_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
1914:

Line 1911: l_invoice_group okl_invoice_formats_v.name%type;

1907: --start: | 15-FEB-07 cklee R12 Billing enhancement project
1908: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;
1909: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;
1910: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;
1911: l_invoice_group okl_invoice_formats_v.name%type;
1912: l_khr_id okc_k_headers_b.id%type;
1913: l_bank_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
1914:
1915: