492: piv.input_value_id,
493: NVL(pet.reporting_name,pet.element_name) element_name,
494: pec.classification_name,
495: piv.uom
496: FROM pay_element_classifications pec,
497: pay_input_values_f piv,
498: pay_element_types_f pet
499: WHERE pec.classification_name IN
500: ('Court Orders',
532: SELECT pet.element_type_id,piv.input_value_id,
533: NVL(pet.reporting_name,pet.element_name) element_name,
534: 'Information',
535: piv.uom
536: FROM pay_element_classifications pec,
537: pay_input_values_f piv,
538: pay_element_types_f pet
539: WHERE pec.classification_name IN ( 'Information')
540: AND pec.business_group_id IS NULL