475: org.ORGANIZATION_ID = stat.ORGANIZATION_ID (+) and
476: stat.ORGANIZATION_ID is null
477: ) org
478: where
479: exists (select /*+ index_ffs(fid, PA_FORECAST_ITEM_DETAILS_N2)
480: parallel_index(fid, PA_FORECAST_ITEM_DETAILS_N2) */ 1
481: from PA_FORECAST_ITEM_DETAILS fid
482: where fid.EXPENDITURE_ORGANIZATION_ID > 0 and
483: fid.EXPENDITURE_ORGANIZATION_ID = org.ORGANIZATION_ID);
476: stat.ORGANIZATION_ID is null
477: ) org
478: where
479: exists (select /*+ index_ffs(fid, PA_FORECAST_ITEM_DETAILS_N2)
480: parallel_index(fid, PA_FORECAST_ITEM_DETAILS_N2) */ 1
481: from PA_FORECAST_ITEM_DETAILS fid
482: where fid.EXPENDITURE_ORGANIZATION_ID > 0 and
483: fid.EXPENDITURE_ORGANIZATION_ID = org.ORGANIZATION_ID);
484:
477: ) org
478: where
479: exists (select /*+ index_ffs(fid, PA_FORECAST_ITEM_DETAILS_N2)
480: parallel_index(fid, PA_FORECAST_ITEM_DETAILS_N2) */ 1
481: from PA_FORECAST_ITEM_DETAILS fid
482: where fid.EXPENDITURE_ORGANIZATION_ID > 0 and
483: fid.EXPENDITURE_ORGANIZATION_ID = org.ORGANIZATION_ID);
484:
485: if (l_extraction_type = 'INCREMENTAL' ) then