807: ) is
808: select pet.element_name, peev.screen_entry_value,
809: piv.name, piv.uom,
810: nvl(petl.reporting_name,petl.element_name)
811: from pay_element_types_f pet,
812: pay_element_types_f_tl petl,
813: pay_element_entries_f pee,
814: pay_element_entry_values_f peev,
815: pay_input_values_f piv
808: select pet.element_name, peev.screen_entry_value,
809: piv.name, piv.uom,
810: nvl(petl.reporting_name,petl.element_name)
811: from pay_element_types_f pet,
812: pay_element_types_f_tl petl,
813: pay_element_entries_f pee,
814: pay_element_entry_values_f peev,
815: pay_input_values_f piv
816: where pet.element_type_id = cp_element_type_id