234: -- dbms_output.put_line('--------till here 3----------');
235:
236: select ia.award_id
237: into l_award_id 238: from igw_awards ia, 239: igw_installments ii
240: where ii.proposal_installment_id = p_proposal_installment_id
241: and ii.proposal_award_id = ia.proposal_award_id;
242: