Product: | IGW - Grants Proposal |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGWFV_GRANT_PROPOSAL_PERS_ASGN |
SELECT PR.PROPOSAL_NUMBER
, PER.PERSON_SEQUENCE
, LKUP1.MEANING
, PER.KEY_PERSON_FLAG
, PER.PERCENT_EFFORT
, PER.PI_FLAG
, PAPF.FULL_NAME
, HR.NAME
, PR.PROPOSAL_ID
, PER.PERSON_ID
, PER.PERSON_ORGANIZATION_ID
, PER.LAST_UPDATE_DATE
, PER.LAST_UPDATED_BY
, PER.CREATION_DATE
, PER.CREATED_BY
FROM IGW_PROP_PERSONS PER
, IGW_PROPOSALS_ALL PR
, IGW_LOOKUPS_V LKUP1
, PER_ALL_PEOPLE_F PAPF
, HR_ALL_ORGANIZATION_UNITS HR
WHERE PR.PROPOSAL_ID = PER.PROPOSAL_ID
AND LKUP1.LOOKUP_TYPE = 'IGW_PROPOSAL_ROLE_TYPES'
AND LKUP1.LOOKUP_CODE = PER.PROPOSAL_ROLE_CODE
AND PAPF.PERSON_ID = PER.PERSON_ID
AND PER.PERSON_ORGANIZATION_ID = HR.ORGANIZATION_ID
AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE
AND PAPF.EFFECTIVE_END_DATE WITH READ ONLY