APPS.PQP_NL_SAVINGS_TEMPLATE dependencies on PAY_TIME_SPANS

Line 28: l_time_span_id pay_time_spans.time_span_id%TYPE;

24: l_comp_id pay_retro_components.retro_component_id%TYPE;
25: l_comp_type pay_retro_components.retro_type%TYPE;
26: l_rc_usage_id pay_retro_component_usages.Retro_Component_Usage_Id%TYPE;
27: l_retro_ele_id pay_element_types_f.element_type_id%TYPE;
28: l_time_span_id pay_time_spans.time_span_id%TYPE;
29: l_es_usage_id pay_element_span_usages.element_span_usage_id%TYPE;
30: l_proc_name VARCHAR2(80);
31: --
32: --

Line 158: pay_time_spans ts

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
162: AND ts.end_time_def_id = e.time_definition_id