Product: | IGW - Grants Proposal |
---|---|
Description: | 10SC Only |
Implementation/DBA Data: | APPS.IGW_BUDGETS_V |
SELECT PB.ROWID
, PB.PROPOSAL_ID
, PB.VERSION_ID
, PB.START_DATE
, PB.END_DATE
, PB.TOTAL_COST
, PB.TOTAL_DIRECT_COST
, PB.TOTAL_INDIRECT_COST
, PB.COST_SHARING_AMOUNT
, PB.UNDERRECOVERY_AMOUNT
, PB.RESIDUAL_FUNDS
, PB.TOTAL_COST_LIMIT
, PB.OH_RATE_CLASS_ID
, PB.PROPOSAL_FORM_NUMBER
, PRC.DESCRIPTION
, PB.COMMENTS
, PB.FINAL_VERSION_FLAG
, PB.BUDGET_TYPE_CODE
, IL.MEANING
, PB.RECORD_VERSION_NUMBER
, PB.ENTER_BUDGET_AT_PERIOD_LEVEL
, PB.APPLY_INFLATION_SETUP_RATES
, PB.APPLY_EB_SETUP_RATES
, PB.APPLY_OH_SETUP_RATES
, PB.LAST_UPDATE_DATE
, PB.LAST_UPDATED_BY
, PB.CREATION_DATE
, PB.CREATED_BY
, PB.LAST_UPDATE_LOGIN
, PB.ATTRIBUTE_CATEGORY
, PB.ATTRIBUTE1
, PB.ATTRIBUTE2
, PB.ATTRIBUTE3
, PB.ATTRIBUTE4
, PB.ATTRIBUTE5
, PB.ATTRIBUTE6
, PB.ATTRIBUTE7
, PB.ATTRIBUTE8
, PB.ATTRIBUTE9
, PB.ATTRIBUTE10
, PB.ATTRIBUTE11
, PB.ATTRIBUTE12
, PB.ATTRIBUTE13
, PB.ATTRIBUTE14
, PB.ATTRIBUTE15
, PRC.DESCRIPTION
, IGW_SECURITY.ALLOW_CREATE('BUDGET'
, PROPOSAL_ID
, FND_GLOBAL.USER_ID)
, IGW_SECURITY.ALLOW_MODIFY('BUDGET'
, PROPOSAL_ID
, FND_GLOBAL.USER_ID)
FROM IGW_BUDGETS PB
, IGW_RATE_CLASSES PRC
, IGW_LOOKUPS_V IL
WHERE PB.OH_RATE_CLASS_ID = PRC.RATE_CLASS_ID AND PB.BUDGET_TYPE_CODE = IL.LOOKUP_CODE AND IL.LOOKUP_TYPE = 'IGW_BUDGET_TYPES'