Product: | IGW - Grants Proposal |
---|---|
Description: | 10SC Only |
Implementation/DBA Data: | APPS.IGW_PROP_PERSONS_V |
SELECT ROWIDTOCHAR(PP.ROWID) ROW_ID
, PP.RECORD_VERSION_NUMBER
, PP.PROPOSAL_ID
, PP.PERSON_ID
, P.FULL_NAME
, PP.PERSON_SEQUENCE
, PP.PROPOSAL_ROLE_CODE
, L.MEANING PROPOSAL_ROLE_DESC
, PP.PI_FLAG
, PP.KEY_PERSON_FLAG
, PP.PERCENT_EFFORT
, PP.PERSON_ORGANIZATION_ID
, ORG.NAME PERSON_UNIT_NAME
, PP.LAST_UPDATE_DATE
, PP.LAST_UPDATED_BY
, PP.CREATION_DATE
, PP.CREATED_BY
, PP.LAST_UPDATE_LOGIN
FROM IGW_PROP_PERSONS PP
, PER_PEOPLE_X P
, FND_LOOKUPS L
, HR_ORGANIZATION_UNITS ORG
WHERE P.PERSON_ID = PP.PERSON_ID
AND L.LOOKUP_CODE = PP.PROPOSAL_ROLE_CODE
AND L.LOOKUP_TYPE = 'IGW_PROPOSAL_ROLE_TYPES'
AND ORG.ORGANIZATION_ID(+) = PP.PERSON_ORGANIZATION_ID