Product: | IGW - Grants Proposal |
---|---|
Description: | 10SC Only |
Implementation/DBA Data: | APPS.IGW_PROP_PERSON_QUESTIONS_V |
SELECT PPPQ.ROWID ROW_ID
, PPPQ.PROPOSAL_ID
, PPPQ.PERSON_ID
, PPPQ.QUESTION_NUMBER
, PQT.DESCRIPTION
, PQ.EXPLANATION_FOR_YES_FLAG
, PQ.EXPLANATION_FOR_NO_FLAG
, PQ.DATE_FOR_YES_FLAG
, PQ.DATE_FOR_NO_FLAG
, PPPQ.ANSWER
, PPPQ.EXPLANATION
, PPPQ.REVIEW_DATE
, PPPQ.LAST_UPDATE_DATE
, PPPQ.LAST_UPDATED_BY
, PPPQ.CREATION_DATE
, PPPQ.CREATED_BY
, PPPQ.LAST_UPDATE_LOGIN
FROM IGW_QUESTIONS PQ
, IGW_PROP_PERSON_QUESTIONS PPPQ
, IGW_QUESTIONS_TL PQT
WHERE PPPQ.QUESTION_NUMBER = PQ.QUESTION_NUMBER
AND PQ.APPLIES_TO = 'I'
AND PPPQ.QUESTION_NUMBER = PQT.QUESTION_NUMBER
AND PQT.LANGUAGE = USERENV('LANG')