APPS.GMS_REPORT_SF269 dependencies on GMS_INSTALLMENTS

Line 462: from gms_installments

458:
459: --7. Get the period federal fund
460: select sum(nvl(direct_cost,0)) + sum(nvl(indirect_cost,0))
461: into l_cum_period_federal_fund
462: from gms_installments
463: where award_id = X_award_id
464: and (X_report_start_date between start_date_active and end_date_active
465: or X_report_End_date between start_date_active and end_date_active );
466: --8. Get the funding period from installments

Line 474: from gms_installments

470: -- Commented for bug 2357578
471: /* select min(start_date_active), max(end_date_active)
472: into l_funding_start_date,
473: l_funding_end_date
474: from gms_installments
475: where award_id = X_award_id; */
476:
477: -- Added for bug 2357578
478: OPEN funding_period_date_cur;