405: else
406: -- Prime cache
407: select ts.time_span_id
408: into l_time_span_id
409: from pay_time_definitions s,
410: pay_time_definitions e,
411: pay_time_spans ts
412: where ts.creator_id = l_comp_id
413: and ts.creator_type = 'RC'
406: -- Prime cache
407: select ts.time_span_id
408: into l_time_span_id
409: from pay_time_definitions s,
410: pay_time_definitions e,
411: pay_time_spans ts
412: where ts.creator_id = l_comp_id
413: and ts.creator_type = 'RC'
414: and ts.start_time_def_id = s.time_definition_id