APPS.OKL_ARINTF_PVT dependencies on OKL_INVOICE_TYPES_V

Line 466: okl_invoice_types_v ity,

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
470: WHERE inf.id = ity.inf_id

Line 483: okl_invoice_types_v ity,

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
487: AND ilt.ity_id = ity.id;

Line 1057: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;

1053: sales_credits_tbl sales_credits_tbl_type;
1054: ar_contingency_tbl ar_contingency_tbl_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;

Line 1058: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;

1054: ar_contingency_tbl ar_contingency_tbl_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;