APPS.PJI_FM_SUM_ACT dependencies on PJI_FM_EXTR_DREVN

Line 344: PJI_FM_EXTR_DREVN drev

340: to_number(null) AR_APPR_INVOICE_COUNT,
341: to_number(null) AR_COUNT_DUE,
342: to_number(null) AR_COUNT_OVERDUE
343: from
344: PJI_FM_EXTR_DREVN drev
345: where
346: drev.WORKER_ID = p_worker_id
347: union all
348: select /*+ parallel(fnd) */ -- funding in functional and project currencies

Line 823: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DREVN' , 'NORMAL',null);

819:
820: -- truncate intermediate tables no longer required
821: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
822: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_FUNDG' , 'NORMAL',null);
823: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DREVN' , 'NORMAL',null);
824: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVC' , 'NORMAL',null);
825: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVCITM' , 'NORMAL',null);
826: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_ARINV' , 'NORMAL',null);
827: