[Home] [Help]
6082:
6083: if (l_extraction_type = 'PARTIAL') then
6084:
6085: delete
6086: from PJI_RM_AGGR_RES6
6087: where PROJECT_ID in (select PROJECT_ID
6088: from PJI_FM_PROJ_BATCH_MAP
6089: where WORKER_ID = p_worker_id);
6090:
6089: where WORKER_ID = p_worker_id);
6090:
6091: end if;
6092:
6093: insert into PJI_RM_AGGR_RES6
6094: (
6095: WORKER_ID,
6096: PROJECT_ID,
6097: PERSON_ID,