DBA Data[Home] [Help]

APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on OKL_INVOICE_FORMATS_V

Line 143: FROM okl_invoice_formats_v inf,

139: SELECT inf.contract_level_yn, -- Multi-contract Y/N
140: ity.group_by_contract_yn, -- Provide Contract Details
141: ity.group_asset_yn, -- Combine Assets
142: inf.name -- invoice group
143: FROM okl_invoice_formats_v inf,
144: okl_invoice_types_v ity,
145: okl_invc_line_types_v ilt,
146: okl_invc_frmt_strms_v frs,
147: okl_strm_type_v sty

Line 160: FROM okl_invoice_formats_v inf,

156: SELECT inf.contract_level_yn, -- Multi-contract Y/N
157: ity.group_by_contract_yn, -- Provide Contract Details
158: ity.group_asset_yn, -- Combine Assets
159: inf.name -- invoice group
160: FROM okl_invoice_formats_v inf,
161: okl_invoice_types_v ity,
162: okl_invc_line_types_v ilt
163: WHERE inf.id = ity.inf_id
164: AND ity.inf_id = p_format_id

Line 908: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;

904: IS
905:
906: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;
907: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;
908: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;
909: l_invoice_group okl_invoice_formats_v.name%type;
910: l_khr_id okc_k_headers_b.id%type;
911: x_tax_det_rec OKL_PROCESS_SALES_TAX_PVT.tax_det_rec_type;
912: l_api_version NUMBER := 1.0;

Line 909: l_invoice_group okl_invoice_formats_v.name%type;

905:
906: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;
907: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;
908: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;
909: l_invoice_group okl_invoice_formats_v.name%type;
910: l_khr_id okc_k_headers_b.id%type;
911: x_tax_det_rec OKL_PROCESS_SALES_TAX_PVT.tax_det_rec_type;
912: l_api_version NUMBER := 1.0;
913: x_msg_count NUMBER;

Line 1668: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;

1664: l_use_inv_org VARCHAR2(10) := NULL;
1665:
1666: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;
1667: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;
1668: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;
1669: l_invoice_group okl_invoice_formats_v.name%type;
1670: l_khr_id okc_k_headers_b.id%type;
1671:
1672: CURSOR acc_sys_option is

Line 1669: l_invoice_group okl_invoice_formats_v.name%type;

1665:
1666: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;
1667: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;
1668: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;
1669: l_invoice_group okl_invoice_formats_v.name%type;
1670: l_khr_id okc_k_headers_b.id%type;
1671:
1672: CURSOR acc_sys_option is
1673: select account_derivation