[Home] [Help]
210: PRVDR_PA_TIME_ID,
211: RECVR_PA_TIME_ID,
212: EXPENDITURE_ITEM_TIME_ID
213: from
214: PJI_FM_DNGL_FIN tmp2
215: where
216: WORKER_ID = 0 and
217: RECORD_TYPE = 'A'
218: ) tmp2,
1778: tmp2.BILL_LABOR_HRS,
1779: tmp2.TOTAL_HRS_A,
1780: tmp2.BILL_HRS_A
1781: from
1782: PJI_FM_DNGL_FIN tmp2,
1783: PJI_FM_PROJ_BATCH_MAP map,
1784: PJI_ORG_EXTR_INFO prj_info,
1785: PJI_ORG_EXTR_INFO res_info,
1786: PJI_FM_AGGR_DLY_RATES prj_gl_rt,
3194: return;
3195: end if;
3196:
3197: /* delete /*+ parallel(fin)
3198: from PJI_FM_DNGL_FIN fin
3199: where WORKER_ID = 0 and
3200: (RECORD_TYPE = 'M' or
3201: ROWID in (select ROW_ID
3202: from PJI_FM_AGGR_FIN2
3202: from PJI_FM_AGGR_FIN2
3203: where WORKER_ID = p_worker_id)); */
3204: -- Commented above and added below for Bug 7357456
3205: -- Spliting the above delete into two different deletes statements
3206: delete from PJI_FM_DNGL_FIN where worker_id = 0 and record_type = 'M';
3207:
3208: delete from PJI_FM_DNGL_FIN where worker_id = 0 and ROWID in (select row_id from PJI_FM_AGGR_FIN2 where worker_id = p_worker_id);
3209: -- End for Bug# 7357456
3210:
3204: -- Commented above and added below for Bug 7357456
3205: -- Spliting the above delete into two different deletes statements
3206: delete from PJI_FM_DNGL_FIN where worker_id = 0 and record_type = 'M';
3207:
3208: delete from PJI_FM_DNGL_FIN where worker_id = 0 and ROWID in (select row_id from PJI_FM_AGGR_FIN2 where worker_id = p_worker_id);
3209: -- End for Bug# 7357456
3210:
3211: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.PURGE_DANGLING_FIN_ROWS(p_worker_id);');
3212:
4358: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.MOVE_DANGLING_FIN_ROWS(p_worker_id);')) then
4359: return;
4360: end if;
4361:
4362: insert into PJI_FM_DNGL_FIN
4363: (
4364: WORKER_ID,
4365: DANGLING_RECVR_GL_RATE_FLAG,
4366: DANGLING_RECVR_GL_RATE2_FLAG,