152: ELSE
153: -- Prime cache
154: SELECT ts.time_span_id
155: INTO l_time_span_id
156: FROM pay_time_definitions s,
157: pay_time_definitions e,
158: pay_time_spans ts
159: WHERE ts.creator_id = l_comp_id
160: AND ts.creator_type = 'RC'
153: -- Prime cache
154: SELECT ts.time_span_id
155: INTO l_time_span_id
156: FROM pay_time_definitions s,
157: pay_time_definitions e,
158: pay_time_spans ts
159: WHERE ts.creator_id = l_comp_id
160: AND ts.creator_type = 'RC'
161: AND ts.start_time_def_id = s.time_definition_id