APPS.PJI_FM_SUM_EXTR dependencies on PJI_FM_AGGR_ACT1

Line 252: PJI_FM_AGGR_ACT1 tmp1

248: PROJECT_ORG_ID,
249: GL_TIME_ID,
250: PA_TIME_ID
251: from
252: PJI_FM_AGGR_ACT1 tmp1
253: where
254: WORKER_ID = p_worker_id
255: ) tmp1,
256: (

Line 5631: PJI_FM_AGGR_ACT1 tmp1,

5627: sum(tmp1.AR_APPR_INVOICE_COUNT) AR_APPR_INVOICE_COUNT,
5628: sum(tmp1.AR_COUNT_DUE) AR_COUNT_DUE,
5629: sum(tmp1.AR_COUNT_OVERDUE) AR_COUNT_OVERDUE
5630: from
5631: PJI_FM_AGGR_ACT1 tmp1,
5632: PJI_ORG_EXTR_INFO prj_info,
5633: PJI_FM_AGGR_DLY_RATES gl_rt,
5634: PJI_FM_AGGR_DLY_RATES pa_rt
5635: where

Line 5709: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_AGGR_ACT1' , 'NORMAL',null);

5705: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.ACT_SUMMARY(p_worker_id);');
5706:
5707: -- truncate intermediate tables no longer required
5708: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
5709: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_AGGR_ACT1' , 'NORMAL',null);
5710:
5711: commit;
5712:
5713: end ACT_SUMMARY;

Line 7655: 'PJI_FM_AGGR_ACT1',

7651: 'NORMAL',
7652: null);
7653:
7654: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
7655: 'PJI_FM_AGGR_ACT1',
7656: 'NORMAL',
7657: null);
7658:
7659: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,