APPS.PJI_FM_SUM_EXTR dependencies on PJI_FM_AGGR_FIN1

Line 165: PJI_FM_AGGR_FIN1 tmp1

161: PRVDR_PA_DATE,
162: RECVR_PA_DATE,
163: EXPENDITURE_ITEM_DATE
164: from
165: PJI_FM_AGGR_FIN1 tmp1
166: where
167: WORKER_ID = p_worker_id
168: ) tmp1,
169: PJI_ORG_EXTR_INFO res_info,

Line 4277: PJI_FM_AGGR_FIN1 tmp1

4273: sum(tmp1.QUANTITY) TOTAL_HRS_A,
4274: sum(tmp1.BILL_QUANTITY) BILL_HRS_A,
4275: tmp1.CBS_ELEMENT_ID CBS_ELEMENT_ID /* Added for CBS Changes */
4276: from
4277: PJI_FM_AGGR_FIN1 tmp1
4278: where
4279: tmp1.WORKER_ID = p_worker_id and
4280: tmp1.EXPENDITURE_ORGANIZATION_ID is not null
4281: group by

Line 4348: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_AGGR_FIN1' , 'NORMAL',null);

4344: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.FIN_SUMMARY(p_worker_id);');
4345:
4346: -- truncate intermediate tables no longer required
4347: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
4348: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_AGGR_FIN1' , 'NORMAL',null);
4349:
4350: commit;
4351:
4352: end FIN_SUMMARY;

Line 7645: 'PJI_FM_AGGR_FIN1',

7641:
7642: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
7643:
7644: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
7645: 'PJI_FM_AGGR_FIN1',
7646: 'NORMAL',
7647: null);
7648:
7649: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,