1316: PJI_RM_AGGR_RES3 tmp3,
1317: PJI_RM_RES_WT_F rmr,
1318: PJI_RES_DELTA delta,
1319: (
1320: select 'TMP3' INVERT_ID from dual union all
1321: select 'RMR' INVERT_ID from dual
1322: ) invert
1323: where
1324: l_extraction_type <> 'PARTIAL' and
1317: PJI_RM_RES_WT_F rmr,
1318: PJI_RES_DELTA delta,
1319: (
1320: select 'TMP3' INVERT_ID from dual union all
1321: select 'RMR' INVERT_ID from dual
1322: ) invert
1323: where
1324: l_extraction_type <> 'PARTIAL' and
1325: tmp3.WORKER_ID = p_worker_id and