[Home] [Help]
381: piv.input_value_id,
382: NVL(pet.reporting_name,pet.element_name) element_name,
383: pec.classification_name,
384: piv.uom
385: FROM pay_element_classifications pec,
386: pay_input_values_f piv,
387: pay_element_types_f pet
388: WHERE pec.classification_name IN ('Court Orders','Voluntary Deductions','Pre Tax Deductions',
389: 'PAYE','NI','Earnings','Direct Payment','Pre NI Deductions','Pre Tax and NI Deductions')
404: piv.input_value_id,
405: NVL(pet.reporting_name,pet.element_name) element_name,
406: pec.classification_name,
407: piv.uom
408: FROM pay_element_classifications pec,
409: pay_input_values_f piv,
410: pay_element_types_f pet
411: WHERE pec.classification_name IN ('Court Orders','Voluntary Deductions','Pre Tax Deductions',
412: 'PAYE','NI','Earnings','Direct Payment','Pre NI Deductions','Pre Tax and NI Deductions')