APPS.IGW_AWARD_PARTICULARS_PKG dependencies on GMS_INSTALLMENTS

Line 18: from gms_installments

14: where proposal_id = i_proposal_id;
15:
16: select sum(direct_cost), sum(direct_cost + indirect_cost)
17: into o_direct_cost, o_total_cost
18: from gms_installments
19: where award_id = i_award_id and
20: active_flag = 'Y' and
21: prop_start_date >= start_date_active and
22: prop_start_date <= nvl(end_date_active, sysdate);

Line 37: from gms_installments

33:
34: Begin
35: select sum(direct_cost), sum(direct_cost + indirect_cost)
36: into o_direct_cost, o_total_cost
37: from gms_installments
38: where award_id = i_award_id;
39: Exception
40: when no_data_found then
41: o_direct_cost := null;