2006:
2007: CURSOR tim_dates is
2008: SELECT effective_start_date,
2009: effective_end_date 2010: FROM HXT_TIMECARDS_X 2011: WHERE id = p_tim_id;
2012:
2013:
2014: -- Local Variables
Line 2214: from hxt_timecards_x tim
2210:
2211: FUNCTION GetPersonID(p_TIM_ID NUMBER) RETURN NUMBER IS
2212: cursor person_cur(c_tim_id NUMBER) is
2213: select tim.for_person_id 2214: from hxt_timecards_x tim 2215: where tim.id = c_tim_id;
2216:
2217: l_person_id NUMBER := NULL;
2218: