Product: | IGW - Grants Proposal |
---|---|
Description: | 10SC Only |
Implementation/DBA Data: | APPS.IGW_PROP_PERSON_DEGREES_V |
SELECT PPPD.ROWID ROW_ID
, PPPD.PROPOSAL_ID
, PPPD.PERSON_DEGREE_ID
, PPPD.SHOW_FLAG
, PPPD.DEGREE_SEQUENCE PROP_DEGREE_SEQUENCE
, PPPD.LAST_UPDATE_DATE
, PPPD.LAST_UPDATED_BY
, PPPD.CREATION_DATE
, PPPD.CREATED_BY
, PPPD.LAST_UPDATE_LOGIN
, PPD.PERSON_ID
, PPD.DEGREE_TYPE_CODE
, PPD.GRADUATION_DATE
, PPD.DEGREE
, PPD.DEGREE_SEQUENCE PERSON_DEGREE_SEQUENCE
, PPD.FIELD_OF_STUDY
, PPD.SPECIALIZATION
, PPD.SCHOOL_NAME
FROM IGW_PROP_PERSON_DEGREES PPPD
, IGW_PERSON_DEGREES PPD
WHERE PPPD.PERSON_DEGREE_ID = PPD.PERSON_DEGREE_ID