VIEW: APPS.IGWFV_GRANT_PROPOSAL_PERS_ASGN

Source

View Text - Preformatted

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

View Text - HTML Formatted

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