512: ELSE
513: -- Prime cache
514: SELECT ts.time_span_id
515: INTO l_time_span_id
516: FROM pay_time_definitions s,
517: pay_time_definitions e,
518: pay_time_spans ts
519: WHERE ts.creator_id = l_comp_id
520: AND ts.creator_type = 'RC'
513: -- Prime cache
514: SELECT ts.time_span_id
515: INTO l_time_span_id
516: FROM pay_time_definitions s,
517: pay_time_definitions e,
518: pay_time_spans ts
519: WHERE ts.creator_id = l_comp_id
520: AND ts.creator_type = 'RC'
521: AND ts.start_time_def_id = s.time_definition_id