VIEW: APPS.IGWFV_GRANT_PRPSL_BDGT_PERSON

Source

View Text - Preformatted

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

View Text - HTML Formatted

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