eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGW_VIEW_PARAMETERS dependencies on GMS_INSTALLMENTS

Line 165: from gms_installments

161: where proposal_id = i_proposal_id;
162:
163: select sum(direct_cost)
164: into o_direct_cost
165: from gms_installments
166: where award_id = i_award_id and
167: active_flag = 'Y' and
168: prop_start_date >= start_date_active and
169: prop_start_date <= nvl(end_date_active, sysdate);

Line 191: from gms_installments

187: where proposal_id = i_proposal_id;
188:
189: select sum(direct_cost + indirect_cost)
190: into o_total_cost
191: from gms_installments
192: where award_id = i_award_id and
193: active_flag = 'Y' and
194: prop_start_date >= start_date_active and
195: prop_start_date <= nvl(end_date_active, sysdate);

Line 210: from gms_installments

206: o_old_direct_cost number;
207: Begin
208: select sum(direct_cost)
209: into o_old_direct_cost
210: from gms_installments
211: where award_id = i_award_id;
212: return o_old_direct_cost;
213: Exception
214: when no_data_found then

Line 226: from gms_installments

222: o_old_total_cost number;
223: Begin
224: select sum(direct_cost + indirect_cost)
225: into o_old_total_cost
226: from gms_installments
227: where award_id = i_award_id;
228: return o_old_total_cost;
229: Exception
230: when no_data_found then