[Home] [Help]
315: g_batch_date_high DATE;
316: g_batch_source_id VARCHAR2(30);
317: g_adjusted_doc_from VARCHAR2(30);
318: g_adjusted_doc_to VARCHAR2(30);
319: g_standard_vat_tax_rate VARCHAR2(30);
320: g_municipal_tax VARCHAR2(30);
321: g_provincial_tax VARCHAR2(30);
322: g_tax_account_low VARCHAR2(30);
323: g_tax_account_high VARCHAR2(30);
866:
867: L_WHERE_TRX_CLASS := '';
868:
869: IF g_include_ap_std_trx_class = 'Y' THEN
870: L_WHERE_TRX_CLASS := L_WHERE_TRX_CLASS || '''STANDARD INVOICES'' ,''PREPAY_APPLICATION'' ,''AMOUNT_MATCHED'' ,' ;
871: END IF;
872:
873: IF g_include_ap_dm_trx_class = 'Y' THEN
874: L_WHERE_TRX_CLASS := L_WHERE_TRX_CLASS || '''AP_DEBIT_MEMO'' ,';
2123: ap_invoice_distributions_all ap_dist,
2124: zx_rates_vl zx_rate
2125: WHERE zx_det.application_id = 200
2126: AND zx_det.entity_code = ''AP_INVOICES''
2127: AND zx_det.event_class_code in (''STANDARD INVOICES'',
2128: ''EXPENSE REPORTS'',
2129: ''PREPAYMENT INVOICES'')
2130: AND zx_det.internal_organization_id = ap_dist.org_id
2131: AND zx_det.trx_id = ap_dist.invoice_id
3882: g_batch_date_high := p_trl_global_variables_rec.batch_date_high;
3883: g_batch_source_id := p_trl_global_variables_rec.batch_source_id;
3884: g_adjusted_doc_from := p_trl_global_variables_rec.adjusted_doc_from;
3885: g_adjusted_doc_to := p_trl_global_variables_rec.adjusted_doc_to;
3886: g_standard_vat_tax_rate := p_trl_global_variables_rec.standard_vat_tax_rate;
3887: g_municipal_tax := p_trl_global_variables_rec.municipal_tax;
3888: g_provincial_tax := p_trl_global_variables_rec.provincial_tax;
3889: g_tax_account_low := p_trl_global_variables_rec.tax_account_low;
3890: g_tax_account_high := p_trl_global_variables_rec.tax_account_high;