Product: | IGW - Grants Proposal |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGWFV_GRNT_PRPSL_PERS_OTHR_SUP |
SELECT PPS.PROP_PERSON_SUPPORT_ID
, PR.PROPOSAL_NUMBER
, PAPF.FULL_NAME
, PAPF2.FULL_NAME
, RA.CUSTOMER_NAME
, '_LA:PPS.SUPPORT_TYPE:IGW_LOOKUPS_V:IGW_SUPPORT_TYPES:MEANING'
, PPS.PROPOSAL_AWARD_NUMBER
, PPS.PROPOSAL_AWARD_TITLE
, PPS.START_DATE
, PPS.END_DATE
, PPS.PERCENT_EFFORT
, PPS.ANNUAL_DIRECT_COST
, PPS.TOTAL_COST
, PPS.PROJECT_LOCATION
, PPS.CALENDAR_START_DATE
, PPS.CALENDAR_END_DATE
, PPS.ACADEMIC_START_DATE
, PPS.ACADEMIC_END_DATE
, PPS.SUMMER_START_DATE
, PPS.SUMMER_END_DATE
, PPS.MAJOR_GOALS
, PPS.OVERLAP
, '_DF:IGW:IGW_PERSON_SUPPORT_DESC_FLEX:PPS'
, PR.PROPOSAL_ID
, PPS.PERSON_ID
, PPS.PI_PERSON_ID
, PPS.SPONSOR_ID
, PPS.LAST_UPDATE_DATE
, PPS.LAST_UPDATED_BY
, PPS.CREATION_DATE
, PPS.CREATED_BY
FROM IGW_PROP_PERSON_SUPPORT PPS
, IGW_PROPOSALS_ALL PR
, PER_ALL_PEOPLE_F PAPF
, PER_ALL_PEOPLE_F PAPF2
, RA_CUSTOMERS RA
WHERE PR.PROPOSAL_ID = PPS.PROPOSAL_ID
AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE
AND PAPF.EFFECTIVE_END_DATE
AND PAPF.PERSON_ID = PPS.PERSON_ID
AND PAPF2.PERSON_ID = PPS.PI_PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PAPF2.EFFECTIVE_START_DATE
AND PAPF2.EFFECTIVE_END_DATE
AND RA.CUSTOMER_ID = PPS.SPONSOR_ID WITH READ ONLY