View: IGWFV_GRNT_PRPSL_BDGT_PERS_AMT

Product:	IGW - Grants Proposal
Description:
Implementation/DBA Data:	APPS.IGWFV_GRNT_PRPSL_BDGT_PERS_AMT

View Text

SELECT PR.PROPOSAL_NUMBER
, PER_DETAILS.VERSION_ID
, PAPF.FULL_NAME
, CLASS.DESCRIPTION
, TYPE.DESCRIPTION
, CAL_AMTS.APPLY_RATE_FLAG
, CAL_AMTS.CALCULATED_COST
, CAL_AMTS.CALCULATED_COST_SHARING
, PR.PROPOSAL_ID
, PER_DETAILS.BUDGET_PERIOD_ID
, PER_DETAILS.LINE_ITEM_ID
, PER_DETAILS.PERSON_ID
, CAL_AMTS.BUDGET_PERSONNEL_DETAIL_ID
, CAL_AMTS.RATE_CLASS_ID
, CAL_AMTS.RATE_TYPE_ID
, CAL_AMTS.LAST_UPDATE_DATE
, CAL_AMTS.LAST_UPDATED_BY
, CAL_AMTS.CREATION_DATE
, CAL_AMTS.CREATED_BY
FROM IGW_BUDGET_PERSONNEL_CAL_AMTS CAL_AMTS
, IGW_BUDGET_PERSONNEL_DETAILS PER_DETAILS
, IGW_PROPOSALS_ALL PR
, PER_ALL_PEOPLE_F PAPF
, IGW_RATE_CLASSES CLASS
, IGW_RATE_TYPES TYPE
WHERE CAL_AMTS.BUDGET_PERSONNEL_DETAIL_ID = PER_DETAILS.BUDGET_PERSONNEL_DETAIL_ID
AND PER_DETAILS.PROPOSAL_ID = PR.PROPOSAL_ID
AND PAPF.PERSON_ID = PER_DETAILS.PERSON_ID
AND CLASS.RATE_CLASS_ID = CAL_AMTS.RATE_CLASS_ID
AND TYPE.RATE_TYPE_ID = CAL_AMTS.RATE_TYPE_ID WITH READ ONLY

Columns