APPS.IGW_VIEW_PARAMETERS SQL Statements

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

Line: 7

    select performing_organization_id
    into o_project_location_id
    from igw_prop_locations
    where proposal_id = i_proposal_id AND
          rownum = 1;

Line: 27

        select name
        into o_project_location_name
        from hr_organization_units
        where organization_id = i_organization_id;

Line: 39

    select substr(abstract, 1, 250)
    into o_major_goals
    from igw_prop_abstracts
    where proposal_id = i_proposal_id AND
          abstract_type = 'IGW_ABSTRACT_TYPES' AND
          abstract_type_code = 'IGW1';

Line: 57

      select proposal_start_date
      into prop_start_date
      from igw_proposals
      where proposal_id = i_proposal_id;

Line: 64

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

Line: 76

           select person_id
           into o_pi_id
           from gms_personnel gp
           where award_id = i_award_id and
                 award_role = 'AM' and
                 rownum = 1;

Line: 96

      select proposal_start_date
      into prop_start_date
      from igw_proposals
      where proposal_id = i_proposal_id;

Line: 104

      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: 116

           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;

Line: 138

              select percent_effort
              into o_percent_effort
              from igw_prop_persons
              where proposal_id = i_proposal_id
              AND person_id = i_person_id;

Line: 158

      select proposal_start_date
      into prop_start_date
      from igw_proposals
      where proposal_id = i_proposal_id;

Line: 163

      select sum(direct_cost)
      into o_direct_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: 184

      select proposal_start_date
      into prop_start_date
      from igw_proposals
      where proposal_id = i_proposal_id;

Line: 189

      select sum(direct_cost + indirect_cost)
      into 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: 208

      select sum(direct_cost)
      into o_old_direct_cost
      from gms_installments
      where award_id = i_award_id;

Line: 224

      select sum(direct_cost + indirect_cost)
      into o_old_total_cost
      from gms_installments
      where award_id = i_award_id;