65: select
66: pettl.element_name
67: from
68: pay_element_entries_f pee
69: ,pay_element_links_f pel
70: ,pay_element_types_f_tl pettl
71: where
72: pee.element_entry_id = p_element_entry_id
73: and pel.element_link_id = pee.element_link_id
807: select
808: pel.element_type_id
809: from
810: pay_element_entries_f pee
811: ,pay_element_links_f pel
812: ,pay_element_types_f_tl pettl
813: where
814: pee.element_entry_id = p_element_entry_id
815: and pee.assignment_id = nvl(p_assignment_id, pee.assignment_id)