[Home] [Help]
View: IGWFV_GRANT_PRPSL_BDGT_PERSON
View Text
SELECT PR.PROPOSAL_NUMBER
, BUD_PERS.VERSION_ID
, '_LA:BUD_PERS.APPOINTMENT_TYPE_CODE:IGW_LOOKUPS_V:IGW_APPOINTMENT_TYPE:MEANING'
, BUD_PERS.EFFECTIVE_DATE
, BUD_PERS.CALCULATION_BASE
, PAPF.FULL_NAME
, PR.PROPOSAL_ID
, BUD_PERS.PERSON_ID
, BUD_PERS.LAST_UPDATE_DATE
, BUD_PERS.LAST_UPDATED_BY
, BUD_PERS.CREATION_DATE
, BUD_PERS.CREATED_BY
FROM IGW_BUDGET_PERSONS BUD_PERS
, IGW_PROPOSALS_ALL PR
, PER_ALL_PEOPLE_F PAPF
WHERE PR.PROPOSAL_ID = BUD_PERS.PROPOSAL_ID
AND PAPF.PERSON_ID = BUD_PERS.PERSON_ID
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE
AND PAPF.EFFECTIVE_END_DATE WITH READ ONLY
Columns
| Name |
| PROPOSAL_NUMBER |
| BUDGET_VERSION_ID |
| "_LA:APPOINTMENT_TYPE" |
| EFFECTIVE_DATE |
| CALCULATION_BASE |
| PERSON_FULL_NAME |
| PROPOSAL_ID |
| PERSON_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATION_DATE |
| CREATED_BY |
APPS.IGWFV_GRANT_PRPSL_BDGT_PERSON