DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_VAT_ACCNT_PKG dependencies on JAI_PA_DRAFT_INVOICES

Line 367: jai_pa_draft_invoices jpdi ,

363: sum(jcdt.func_tax_amt) func_tax_amount ,
364: max(jpdi.last_update_date) creation_date ,
365: jcdt.tax_type tax_type
366: FROM
367: jai_pa_draft_invoices jpdi ,
368: jai_pa_draft_invoice_lines jpdil ,
369: jai_cmn_document_taxes jcdt ,
370: (
371: SELECT jrttv1.tax_type tax_type

Line 613: lv_source_table_name := jai_pa_billing_pkg.gv_draft_invoice_table; -- 'JAI_PA_DRAFT_INVOICES';

609:
610: elsif p_source = jai_pa_billing_pkg.gv_source_projects then
611: record_debug_messages ('6 Projects Draft Invoice PROCESSING');
612: lv_source_trx_type := jai_pa_billing_pkg.gv_trx_type_draft_invoice; -- 'DRAFT_INVOICE';
613: lv_source_table_name := jai_pa_billing_pkg.gv_draft_invoice_table; -- 'JAI_PA_DRAFT_INVOICES';
614: lv_called_from := p_called_from;
615: lv_attribute_context := jai_pa_billing_pkg.gv_draft_invoice_release; -- 'DRAFT_INVOICE_RELEASE';
616: -- added by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), begin
617: elsif p_source = upper(jai_constants.source_nsh) then