DBA Data[Home] [Help]

APPS.PJI_RM_SUM_EXTR dependencies on DUAL

Line 1320: select 'TMP3' INVERT_ID from dual union all

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

Line 1321: select 'RMR' INVERT_ID from dual

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