440: ELSE
441: -- Prime cache
442: SELECT ts.time_span_id
443: INTO l_time_span_id
444: FROM pay_time_definitions s,
445: pay_time_definitions e,
446: pay_time_spans ts
447: WHERE ts.creator_id = l_comp_id
448: AND ts.creator_type = 'RC'
441: -- Prime cache
442: SELECT ts.time_span_id
443: INTO l_time_span_id
444: FROM pay_time_definitions s,
445: pay_time_definitions e,
446: pay_time_spans ts
447: WHERE ts.creator_id = l_comp_id
448: AND ts.creator_type = 'RC'
449: AND ts.start_time_def_id = s.time_definition_id