APPS.PAY_NL_LIFE_SAVINGS_TEMPLATE dependencies on PAY_ELEMENT_SPAN_USAGES

Line 317: l_es_usage_id pay_element_span_usages.element_span_usage_id%TYPE;

313: l_comp_type pay_retro_components.retro_type%TYPE;
314: l_rc_usage_id pay_retro_component_usages.Retro_Component_Usage_Id%TYPE;
315: l_retro_ele_id pay_element_types_f.element_type_id%TYPE;
316: l_time_span_id pay_time_spans.time_span_id%TYPE;
317: l_es_usage_id pay_element_span_usages.element_span_usage_id%TYPE;
318: l_proc_name VARCHAR2(80);
319: --
320: --
321: --

Line 472: FROM pay_element_span_usages

468: --
469: BEGIN
470: SELECT element_span_usage_id
471: INTO l_es_usage_id
472: FROM pay_element_span_usages
473: WHERE time_span_id = l_time_span_id
474: AND retro_component_usage_id = l_rc_usage_id
475: AND adjustment_type IS NULL;
476:

Line 478: SELECT pay_element_span_usages_s.NEXTVAL

474: AND retro_component_usage_id = l_rc_usage_id
475: AND adjustment_type IS NULL;
476:
477: EXCEPTION WHEN no_data_found THEN
478: SELECT pay_element_span_usages_s.NEXTVAL
479: INTO l_es_usage_id
480: FROM dual;
481:
482: IF g_debug THEN

Line 486: INSERT INTO pay_element_span_usages(

482: IF g_debug THEN
483: hr_utility.set_location('Insert Element Span Usgs '||l_proc_name, 30);
484: END IF;
485:
486: INSERT INTO pay_element_span_usages(
487: ELEMENT_SPAN_USAGE_ID,
488: BUSINESS_GROUP_ID,
489: LEGISLATION_CODE,
490: TIME_SPAN_ID,