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 5621: PJI_FM_AGGR_ACT1 tmp1,

5617: sum(tmp1.AR_APPR_INVOICE_COUNT) AR_APPR_INVOICE_COUNT,
5618: sum(tmp1.AR_COUNT_DUE) AR_COUNT_DUE,
5619: sum(tmp1.AR_COUNT_OVERDUE) AR_COUNT_OVERDUE
5620: from
5621: PJI_FM_AGGR_ACT1 tmp1,
5622: PJI_ORG_EXTR_INFO prj_info,
5623: PJI_FM_AGGR_DLY_RATES gl_rt,
5624: PJI_FM_AGGR_DLY_RATES pa_rt
5625: where

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

5695: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.ACT_SUMMARY(p_worker_id);');
5696:
5697: -- truncate intermediate tables no longer required
5698: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
5699: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_AGGR_ACT1' , 'NORMAL',null);
5700:
5701: commit;
5702:
5703: end ACT_SUMMARY;

Line 7275: 'PJI_FM_AGGR_ACT1',

7271: 'NORMAL',
7272: null);
7273:
7274: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
7275: 'PJI_FM_AGGR_ACT1',
7276: 'NORMAL',
7277: null);
7278:
7279: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,