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 4270: PJI_FM_AGGR_FIN1 tmp1

4266: 'OT', tmp1.BILL_QUANTITY, 0)) BILL_LABOR_HRS,
4267: sum(tmp1.QUANTITY) TOTAL_HRS_A,
4268: sum(tmp1.BILL_QUANTITY) BILL_HRS_A
4269: from
4270: PJI_FM_AGGR_FIN1 tmp1
4271: where
4272: tmp1.WORKER_ID = p_worker_id and
4273: tmp1.EXPENDITURE_ORGANIZATION_ID is not null
4274: group by

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

4336: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.FIN_SUMMARY(p_worker_id);');
4337:
4338: -- truncate intermediate tables no longer required
4339: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
4340: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_AGGR_FIN1' , 'NORMAL',null);
4341:
4342: commit;
4343:
4344: end FIN_SUMMARY;

Line 7265: 'PJI_FM_AGGR_FIN1',

7261:
7262: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
7263:
7264: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
7265: 'PJI_FM_AGGR_FIN1',
7266: 'NORMAL',
7267: null);
7268:
7269: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,