APPS.PQP_NL_SAVINGS_TEMPLATE dependencies on PAY_ELEMENT_SPAN_USAGES

Line 29: l_es_usage_id pay_element_span_usages.element_span_usage_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: --
33: --

Line 184: FROM pay_element_span_usages

180: --
181: BEGIN
182: SELECT element_span_usage_id
183: INTO l_es_usage_id
184: FROM pay_element_span_usages
185: WHERE time_span_id = l_time_span_id
186: AND retro_component_usage_id = l_rc_usage_id
187: AND adjustment_type IS NULL;
188:

Line 190: SELECT pay_element_span_usages_s.NEXTVAL

186: AND retro_component_usage_id = l_rc_usage_id
187: AND adjustment_type IS NULL;
188:
189: EXCEPTION WHEN no_data_found THEN
190: SELECT pay_element_span_usages_s.NEXTVAL
191: INTO l_es_usage_id
192: FROM dual;
193:
194: IF g_debug THEN

Line 198: INSERT INTO pay_element_span_usages(

194: IF g_debug THEN
195: hr_utility.set_location('Insert Element Span Usgs '||l_proc_name, 30);
196: END IF;
197:
198: INSERT INTO pay_element_span_usages(
199: ELEMENT_SPAN_USAGE_ID,
200: BUSINESS_GROUP_ID,
201: LEGISLATION_CODE,
202: TIME_SPAN_ID,