312: from sys.dual
313: where exists
314: (select 1
315: from pay_element_set_members esm,
316: pay_element_sets es
317: where esm.element_type_id = p_element_type_id
318: and es.element_set_id = esm.element_set_id
319: and es.element_set_type = 'D');
320: --
360: begin
361: --
362: select 'N'
363: into l_validation_ok
364: from pay_element_sets es
365: where es.element_set_id = p_element_set_id
366: and exists
367: (select 1
368: from pay_element_set_members esm,