PSPBV_LABOR_DIST_ELEMENT_TYPES displays information about earnings elements defined in Oracle Human Resources and Payroll and imported to Labor Distribution.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT PET.ELEMENT_TYPE_ID , PET.START_DATE_ACTIVE , PET.END_DATE_ACTIVE , PET.COMMENTS , PET.LAST_UPDATE_DATE , PET.LAST_UPDATED_BY , PET.CREATED_BY , PET.CREATION_DATE FROM PSP_ELEMENT_TYPES PET , PAY_ELEMENT_TYPES PET1 WHERE PET.ELEMENT_TYPE_ID=PET1.ELEMENT_TYPE_ID AND PET.START_DATE_ACTIVE BETWEEN PET1.EFFECTIVE_START_DATE AND PET1.EFFECTIVE_END_DATE WITH READ ONLY