View: PA_BILL_RATES_EMP

Product:	PA - Projects
Description:	10SC Only
Implementation/DBA Data:	APPS.PA_BILL_RATES_EMP

View Text

SELECT B.ROWID
, B.BILL_RATE_SCH_ID
, B.BILL_RATE_ORGANIZATION_ID
, B.STD_BILL_RATE_SCHEDULE
, B.PERSON_ID
, P.FULL_NAME
, DECODE(P.CURRENT_NPW_FLAG
, 'Y'
, P.NPW_NUMBER
, P.EMPLOYEE_NUMBER)
, B.JOB_ID
, NULL
, B.EXPENDITURE_TYPE
, B.NON_LABOR_RESOURCE
, NULL
, NULL
, NULL
, B.RATE
, L.MEANING
, B.BILL_RATE_UNIT
, B.MARKUP_PERCENTAGE
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.JOB_GROUP_ID
, B.RATE_CURRENCY_CODE
, B.RESOURCE_CLASS_CODE
, NULL
, B.RES_CLASS_ORGANIZATION_ID
FROM FND_LOOKUP_VALUES L
, PER_PEOPLE_F P
, PA_BILL_RATES B
WHERE P.PERSON_ID = B.PERSON_ID
AND P.EFFECTIVE_START_DATE = (SELECT MIN(PP.EFFECTIVE_START_DATE)
FROM PER_ALL_PEOPLE_F PP
WHERE PP.PERSON_ID = P.PERSON_ID
AND PP.EFFECTIVE_END_DATE > SYSDATE)
AND L.LOOKUP_TYPE = 'UNIT'
AND L.LOOKUP_CODE = B.BILL_RATE_UNIT
AND L.LANGUAGE = USERENV('LANG')
AND L.VIEW_APPLICATION_ID = 275

Columns