APPS.OKL_ARINTF_PVT dependencies on OKL_INVOICE_FORMATS_V

Line 465: FROM okl_invoice_formats_v inf,

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

Line 482: FROM okl_invoice_formats_v inf,

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

Line 1059: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;

1055:
1056: --start: | 15-FEB-07 cklee R12 Billing enhancement project
1057: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;
1058: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;
1059: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;
1060: l_invoice_group okl_invoice_formats_v.name%type;
1061: l_khr_id okc_k_headers_b.id%type;
1062: l_bank_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
1063:

Line 1060: l_invoice_group okl_invoice_formats_v.name%type;

1056: --start: | 15-FEB-07 cklee R12 Billing enhancement project
1057: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;
1058: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;
1059: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;
1060: l_invoice_group okl_invoice_formats_v.name%type;
1061: l_khr_id okc_k_headers_b.id%type;
1062: l_bank_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
1063:
1064: