DBA Data[Home] [Help]

APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on OKL_INVOICE_FORMATS_V

Line 401: FROM okl_invoice_formats_v inf,

397: SELECT inf.contract_level_yn, -- Multi-contract Y/N
398: ity.group_by_contract_yn, -- Provide Contract Details
399: ity.group_asset_yn, -- Combine Assets
400: inf.name -- invoice group
401: FROM okl_invoice_formats_v inf,
402: okl_invoice_types_v ity,
403: okl_invc_line_types_v ilt,
404: okl_invc_frmt_strms_v frs,
405: okl_strm_type_v sty

Line 418: FROM okl_invoice_formats_v inf,

414: SELECT inf.contract_level_yn, -- Multi-contract Y/N
415: ity.group_by_contract_yn, -- Provide Contract Details
416: ity.group_asset_yn, -- Combine Assets
417: inf.name -- invoice group
418: FROM okl_invoice_formats_v inf,
419: okl_invoice_types_v ity,
420: okl_invc_line_types_v ilt
421: WHERE inf.id = ity.inf_id
422: AND ity.inf_id = p_format_id

Line 1116: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;

1112: IS
1113:
1114: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;
1115: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;
1116: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;
1117: l_invoice_group okl_invoice_formats_v.name%type;
1118: l_khr_id okc_k_headers_b.id%type;
1119: x_tax_det_rec OKL_PROCESS_SALES_TAX_PVT.tax_det_rec_type;
1120: l_api_version NUMBER := 1.0;

Line 1117: l_invoice_group okl_invoice_formats_v.name%type;

1113:
1114: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;
1115: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;
1116: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;
1117: l_invoice_group okl_invoice_formats_v.name%type;
1118: l_khr_id okc_k_headers_b.id%type;
1119: x_tax_det_rec OKL_PROCESS_SALES_TAX_PVT.tax_det_rec_type;
1120: l_api_version NUMBER := 1.0;
1121: x_msg_count NUMBER;

Line 1876: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;

1872: l_use_inv_org VARCHAR2(10) := NULL;
1873:
1874: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;
1875: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;
1876: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;
1877: l_invoice_group okl_invoice_formats_v.name%type;
1878: l_khr_id okc_k_headers_b.id%type;
1879:
1880: CURSOR acc_sys_option is

Line 1877: l_invoice_group okl_invoice_formats_v.name%type;

1873:
1874: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;
1875: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;
1876: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;
1877: l_invoice_group okl_invoice_formats_v.name%type;
1878: l_khr_id okc_k_headers_b.id%type;
1879:
1880: CURSOR acc_sys_option is
1881: select account_derivation