172: begin
173: select distinct pee.element_entry_id
174: into l_element_entry_id
175: from
176: pay_element_types_f_tl pettl
177: ,pay_element_types_f pet
178: ,pay_element_links_f pel
179: ,pay_element_entries_f pee
180: where
173: select distinct pee.element_entry_id
174: into l_element_entry_id
175: from
176: pay_element_types_f_tl pettl
177: ,pay_element_types_f pet
178: ,pay_element_links_f pel
179: ,pay_element_entries_f pee
180: where
181: pettl.element_name = p_element_name