APPS.IGW_AWARD_PARTICULARS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

      select proposal_start_date
      into prop_start_date
      from igw_proposals
      where proposal_id = i_proposal_id;

Line: 16

      select sum(direct_cost), sum(direct_cost + indirect_cost)
      into o_direct_cost, o_total_cost
      from gms_installments
      where award_id = i_award_id and
          active_flag = 'Y' and
          prop_start_date >= start_date_active and
          prop_start_date <= nvl(end_date_active, sysdate);

Line: 35

      select sum(direct_cost), sum(direct_cost + indirect_cost)
      into o_direct_cost, o_total_cost
      from gms_installments
      where award_id = i_award_id;

Line: 50

      select proposal_start_date
      into prop_start_date
      from igw_proposals
      where proposal_id = i_proposal_id;

Line: 58

      select gp.person_id, ppx.full_name
      into o_pi_id, o_pi_name
      from gms_personnel gp, per_people_x ppx
      where gp.award_id = i_award_id and
            gp.award_role = 'AM' and
            prop_start_date >= gp.start_date_active and
            prop_start_date <= nvl(gp.end_date_active, sysdate) and
            gp.person_id = ppx.person_id;

Line: 69

           select gp.person_id, ppx.full_name
           into o_pi_id, o_pi_name
           from gms_personnel gp, per_people_x ppx
           where gp.award_id = i_award_id and
                 gp.award_role = 'AM' and
                 gp.person_id = ppx.person_id and
                 rownum = 1;