APPS.GMS_BUDGET_PUB dependencies on GMS_INSTALLMENTS

Line 911: from gms_installments gi,

907: gspf.total_funding_amount total_funding_amount,
908: trunc(gi.start_date_active) start_date_active,
909: nvl(trunc(ga.preaward_date),trunc(gi.start_date_active)) start_date_active_preawd, -- for Bug: 1906414
910: trunc(gi.end_date_active) end_date_active
911: from gms_installments gi,
912: gms_awards ga,
913: gms_summary_project_fundings gspf
914: where gi.installment_id = gspf.installment_id
915: and ga.award_id = gi.award_id

Line 1022: gms_installments gi

1018:
1019: select sum(nvl(total_funding_amount,0))
1020: into l_total_funding_amount
1021: from gms_summary_project_fundings gspf,
1022: gms_installments gi
1023: where gspf.installment_id = gi.installment_id
1024: and gi.award_id = x_award_id
1025: and gspf.project_id = x_project_id;
1026:

Line 1065: from gms_installments gi,

1061: and pbem.budget_entry_method_code = gbv.budget_entry_method_code;
1062:
1063: select decode (task_id, NULL, 'P','T')
1064: into x_funding_level
1065: from gms_installments gi,
1066: gms_summary_project_fundings gspf
1067: where gi.installment_id = gspf.installment_id
1068: and gi.award_id = x_award_id
1069: and gspf.project_id = x_project_id