Product: | GMS - Grants Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.GMS_PERSONNEL_V |
SELECT P.PERSONNEL_ID
, P.AWARD_ID
, P.PERSON_ID
, P.AWARD_ROLE
, P.START_DATE_ACTIVE
, P.END_DATE_ACTIVE
, PER.FULL_NAME
, LP.MEANING
, P.REQUIRED_FLAG
, P.LAST_UPDATE_DATE
, P.LAST_UPDATED_BY
, P.CREATION_DATE
, P.CREATED_BY
, P.LAST_UPDATE_LOGIN
, P.ROWID
FROM GMS_PERSONNEL P
, GMS_LOOKUPS LP
, PER_PEOPLE_X PER
WHERE LP.LOOKUP_TYPE = 'AWARD_ROLE'
AND LP.LOOKUP_CODE = P.AWARD_ROLE
AND PER.PERSON_ID = P.PERSON_ID