280: CURSOR weekly_total
281: IS
282: SELECT NVL (SUM (hrw.hours), 0)
283: FROM hxt_det_hours_worked hrw, --C421
284: hxt_timecards tim,
285: hxt_earn_groups erg,
286: hxt_earn_group_types egt,
287: hxt_earning_policies erp
288: -- WHERE tim.id = a_tim_id
375: CURSOR weekly_total
376: IS
377: SELECT NVL (SUM (hrw.hours), 0)
378: FROM hxt_det_hours_worked hrw, --C421
379: hxt_timecards tim,
380: hxt_earn_groups erg,
381: hxt_earn_group_types egt,
382: hxt_earning_policies erp
383: -- WHERE tim.id = a_tim_id