[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,
1781: tmp2.TOTAL_HRS_A,
1782: tmp2.BILL_HRS_A,
1783: tmp2.CBS_ELEMENT_ID /*Added for CBS Changes */
1784: from
1785: PJI_FM_DNGL_FIN tmp2,
1786: PJI_FM_PROJ_BATCH_MAP map,
1787: PJI_ORG_EXTR_INFO prj_info,
1788: PJI_ORG_EXTR_INFO res_info,
1789: PJI_FM_AGGR_DLY_RATES prj_gl_rt,
3197: return;
3198: end if;
3199:
3200: /* delete /*+ parallel(fin)
3201: from PJI_FM_DNGL_FIN fin
3202: where WORKER_ID = 0 and
3203: (RECORD_TYPE = 'M' or
3204: ROWID in (select ROW_ID
3205: from PJI_FM_AGGR_FIN2
3205: from PJI_FM_AGGR_FIN2
3206: where WORKER_ID = p_worker_id)); */
3207: -- Commented above and added below for Bug 7357456
3208: -- Spliting the above delete into two different deletes statements
3209: delete from PJI_FM_DNGL_FIN where worker_id = 0 and record_type = 'M';
3210:
3211: 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);
3212: -- End for Bug# 7357456
3213:
3207: -- Commented above and added below for Bug 7357456
3208: -- Spliting the above delete into two different deletes statements
3209: delete from PJI_FM_DNGL_FIN where worker_id = 0 and record_type = 'M';
3210:
3211: 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);
3212: -- End for Bug# 7357456
3213:
3214: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.PURGE_DANGLING_FIN_ROWS(p_worker_id);');
3215:
4366: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.MOVE_DANGLING_FIN_ROWS(p_worker_id);')) then
4367: return;
4368: end if;
4369:
4370: insert into PJI_FM_DNGL_FIN
4371: (
4372: WORKER_ID,
4373: DANGLING_RECVR_GL_RATE_FLAG,
4374: DANGLING_RECVR_GL_RATE2_FLAG,