SELECT PE.FULL_NAME , EM.EFFECTIVE_DATE , EM.HOURLY_LABOR_RATE , PA.ORGANIZATION_CODE , AL.NAME , '_DF:WIP:WIP_LABOR_RATES:EM' , EM.EMPLOYEE_ID , EM.ORGANIZATION_ID , EM.CREATION_DATE , EM.CREATED_BY , EM.LAST_UPDATE_DATE , EM.LAST_UPDATED_BY FROM PER_ALL_PEOPLE_F PE , WIP_PARAMETERS PARA , HR_ALL_ORGANIZATION_UNITS AL , MTL_PARAMETERS PA , WIP_EMPLOYEE_LABOR_RATES EM WHERE EM.ORGANIZATION_ID = PA.ORGANIZATION_ID AND EM.ORGANIZATION_ID = AL.ORGANIZATION_ID AND EM.ORGANIZATION_ID = PARA.ORGANIZATION_ID AND EM.EMPLOYEE_ID = PE.PERSON_ID AND EM.EFFECTIVE_DATE >= PE.EFFECTIVE_START_DATE AND EM.EFFECTIVE_DATE <=PE.EFFECTIVE_END_DATE AND '_SEC:EM.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY