GMS_AWARD_BUDGET_FUNDINGS_V

Details

• Schema: FUSION

• Object owner: GMS

• Object type: VIEW

Columns

Name
BUDGET_PERIOD_ID AWARD_ID SEQ_NUM BUDGET_PERIOD START_DATE END_DATE AWARD_FUNDING_SOURCE_ID FUNDING_SOURCE_ID

Query

SQL_Statement
select a.id as budget_Period_id, a.award_id, a.seq_num, a.budget_period, a.start_date, a.end_date, b.id as award_funding_source_id, b.funding_source_id from gms_award_budget_periods a, gms_award_funding_sources_b b where a.award_id= b.award_id and TRUNC(sysdate) >= TRUNC(a.start_date)