APPS.PJI_FM_SUM_ACT dependencies on PJI_FM_EXTR_FUNDG

Line 509: PJI_FM_EXTR_FUNDG fnd

505: to_number(null) AR_APPR_INVOICE_COUNT,
506: to_number(null) AR_COUNT_DUE,
507: to_number(null) AR_COUNT_OVERDUE
508: from
509: PJI_FM_EXTR_FUNDG fnd
510: where
511: fnd.WORKER_ID = p_worker_id
512: union all
513: select /*+ parallel(fin1) */ -- FIN_TMP1 in functional and project currency

Line 822: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_FUNDG' , 'NORMAL',null);

818: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ACT.BASE_SUMMARY(p_worker_id);');
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);