320: --
321: IF ( p_position_id IS NOT NULL )
322: THEN
323: -- 324: -- get position's standard hours 325: --
326: OPEN get_pos_std_hrs;
327: FETCH get_pos_std_hrs INTO l_std_hrs;
328: CLOSE get_pos_std_hrs;
Line 332: -- get organization's standard hours
328: CLOSE get_pos_std_hrs;
329: --
330: ELSE
331: -- 332: -- get organization's standard hours 333: --
334: OPEN get_org_std_hrs;
335: FETCH get_org_std_hrs INTO l_std_hrs;
336: CLOSE get_org_std_hrs;