117:
118: /* Check whether a snapshot can be used */
119: /* Note a snapshot may be used to get the total even if the portlet query */
120: /* is not able to use snapshots */
121: l_use_snapshot := hri_oltp_pmv_util_snpsht.use_wcnt_chg_snpsht_for_mgr
122: (p_supervisor_id => p_supervisor_id,
123: p_effective_date => p_to_date);
124:
125: /* Set record type indicator */
202:
203: /* Check whether a snapshot can be used */
204: /* Note a snapshot may be used to get the total even if the portlet query */
205: /* is not able to use snapshots */
206: l_use_snapshot := hri_oltp_pmv_util_snpsht.use_wcnt_chg_snpsht_for_mgr
207: (p_supervisor_id => p_supervisor_id,
208: p_effective_date => p_to_date);
209:
210: /* Set record type indicator */
280:
281: /* Check whether a snapshot can be used */
282: /* Note a snapshot may be used to get the total even if the portlet query */
283: /* is not able to use snapshots */
284: l_use_snapshot := hri_oltp_pmv_util_snpsht.use_wcnt_chg_snpsht_for_mgr
285: (p_supervisor_id => p_supervisor_id,
286: p_effective_date => p_to_date);
287:
288: /* Set record type indicator */