VIEW: APPS.PA_BILL_RATES_EMP

Source

View Text - Preformatted

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

View Text - HTML Formatted

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