APPS.GMS_BUDGET_PUB dependencies on GMS_SUMMARY_PROJECT_FUNDINGS

Line 913: gms_summary_project_fundings gspf

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
916: and gi.award_id = x_award_id
917: and gspf.project_id = x_project_id

Line 1021: from gms_summary_project_fundings gspf,

1017: end;
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;

Line 1066: gms_summary_project_fundings gspf

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
1070: and rownum = 1;