582: IS
583: CURSOR get_timecard_id (p_tim_sum_id NUMBER)
584: IS
585: SELECT hshw.tim_id, ht.time_period_id
586: FROM hxt_sum_hours_worked hshw, hxt_timecards ht
587: WHERE hshw.ID = p_tim_sum_id AND hshw.tim_id = ht.ID;
588:
589: CURSOR get_debug
590: IS
1868:
1869: CURSOR get_timecard_id (p_tim_sum_id NUMBER)
1870: IS
1871: SELECT hshw.tim_id, ht.time_period_id
1872: FROM hxt_sum_hours_worked hshw, hxt_timecards ht
1873: WHERE hshw.ID = p_tim_sum_id AND hshw.tim_id = ht.ID;
1874:
1875: CURSOR get_debug
1876: IS