APPS.PQP_NL_SAVINGS_TEMPLATE dependencies on DUAL

Line 108: FROM dual;

104: AND creator_type = p_creator_type;
105: EXCEPTION WHEN no_data_found THEN
106: SELECT pay_retro_component_usages_s.NEXTVAL
107: INTO l_rc_usage_id
108: FROM dual;
109: --
110: IF g_debug THEN
111: hr_utility.set_location('Insert Retro Comp Usgs '||l_proc_name, 20);
112: END IF;

Line 192: FROM dual;

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