277: --
278: IF ( p_position_id IS NOT NULL )
279: THEN
280: -- 281: -- get position's standard hours 282: --
283: OPEN get_pos_std_hrs;
284: FETCH get_pos_std_hrs INTO l_std_hrs;
285: CLOSE get_pos_std_hrs;
Line 289: -- get organization's standard hours
285: CLOSE get_pos_std_hrs;
286: --
287: ELSE
288: -- 289: -- get organization's standard hours 290: --
291: OPEN get_org_std_hrs;
292: FETCH get_org_std_hrs INTO l_std_hrs;
293: CLOSE get_org_std_hrs;