[Home] [Help]
6072:
6073: if (l_extraction_type = 'PARTIAL') then
6074:
6075: delete
6076: from PJI_RM_AGGR_RES6
6077: where PROJECT_ID in (select PROJECT_ID
6078: from PJI_FM_PROJ_BATCH_MAP
6079: where WORKER_ID = p_worker_id);
6080:
6079: where WORKER_ID = p_worker_id);
6080:
6081: end if;
6082:
6083: insert into PJI_RM_AGGR_RES6
6084: (
6085: WORKER_ID,
6086: PROJECT_ID,
6087: PERSON_ID,