APPS.PQP_NL_ABP_TEMPLATE dependencies on PAY_TIME_SPANS

Line 308: l_time_span_id pay_time_spans.time_span_id%TYPE;

304: l_comp_id pay_retro_components.retro_component_id%TYPE;
305: l_comp_type pay_retro_components.retro_type%TYPE;
306: l_rc_usage_id pay_retro_component_usages.Retro_Component_Usage_Id%TYPE;
307: l_retro_ele_id pay_element_types_f.element_type_id%TYPE;
308: l_time_span_id pay_time_spans.time_span_id%TYPE;
309: l_es_usage_id pay_element_span_usages.element_span_usage_id%TYPE;
310: begin
311: if g_creator.name = p_creator_name
312: and g_creator.type = p_creator_type

Line 411: pay_time_spans ts

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
415: and ts.end_time_def_id = e.time_definition_id