APPS.IGW_PROP_COSTS SQL Statements

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

Line: 7

    select ibp.total_direct_cost
    into o_annual_cost
    from igw_budget_periods  ibp, igw_budgets  ib
    where ibp.proposal_id = i_prop_id and
          ibp.proposal_id = ib.proposal_id  and
          ibp.version_id = ib.version_id and
          ib.final_version_flag = 'Y' and
          ibp.budget_period_id = 1;

Line: 28

    select total_cost
    into o_total_cost
    from igw_budgets
    where proposal_id = i_prop_id and
          final_version_flag = 'Y';