DBA Data[Home] [Help]

APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 496: FROM pay_element_classifications pec,

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',

Line 536: FROM pay_element_classifications pec,

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