APPS.PAY_NL_LIFE_SAVINGS_TEMPLATE dependencies on DUAL

Line 396: FROM dual;

392: AND creator_type = p_creator_type;
393: EXCEPTION WHEN no_data_found THEN
394: SELECT pay_retro_component_usages_s.NEXTVAL
395: INTO l_rc_usage_id
396: FROM dual;
397: --
398: IF g_debug THEN
399: hr_utility.set_location('Insert Retro Comp Usgs '||l_proc_name, 20);
400: END IF;

Line 480: FROM dual;

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
483: hr_utility.set_location('Insert Element Span Usgs '||l_proc_name, 30);
484: END IF;