545: dlt.pow_extn_days_julian * dlt.primary_flag_ind * dlt.metric_adjust_multiplier * dlt.direct_ind
546: ELSE
547: (dlt.pow_extn_days_julian * dlt.primary_flag_ind * dlt.metric_adjust_multiplier * dlt.direct_ind) * -1
548: END) dr_primary_pow_extn_adjust
549: FROM mlog$_hri_map_sup_wrkfc_as dlt
550: WHERE dlt.supervisor_person_id between p_start_object_id and p_end_object_id
551: GROUP BY dlt.supervisor_person_id
552: ,dlt.effective_date
553: ,dlt.geo_area_code
899: --
900: p_sqlstr :=
901: 'SELECT /*+ parallel (EQ, default, default) */
902: DISTINCT supervisor_person_id object_id
903: FROM mlog$_hri_map_sup_wrkfc_as eq
904: ORDER BY supervisor_person_id';
905: --
906: -- End of Incremental Refresh Section
907: -- -------------------------------------------------------------------------