VIEW: APPS.WIPBV_WIP_EMPLOYEE_LABOR_RATES

Source

View Text - Preformatted

SELECT PE.FULL_NAME , EM.EFFECTIVE_DATE , EM.HOURLY_LABOR_RATE , PA.ORGANIZATION_CODE , AL.NAME , 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

View Text - HTML Formatted

SELECT PE.FULL_NAME
, EM.EFFECTIVE_DATE
, EM.HOURLY_LABOR_RATE
, PA.ORGANIZATION_CODE
, AL.NAME
, 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