798: select eei2.element_type_extra_info_id
799: ,eei1.element_type_id
800: from pay_element_type_extra_info eei1
801: ,pay_element_type_extra_info eei2
802: ,hr_lookups hrl
803: ,pay_element_types_f petf
804: where hrl.lookup_type = 'PQP_RATE_TYPE'
805: and hrl.meaning = c_name
806: and eei1.eei_information1 = hrl.lookup_code