APPS.IGW_OVERHEAD_CAL SQL Statements

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

Line: 53

    select rc.rate_class_id
    ,      rt.rate_type_id
    from   igw_rate_classes 	  rc
    , 	   igw_rate_types 	  rt
    ,	   igw_exp_type_rate_types rct
    where  rc.rate_class_id = rt.rate_class_id
    and	   rt.rate_type_id = rct.rate_type_id
    and    rc.rate_class_id = rct.rate_class_id
    and    rct.expenditure_category = l_parent_category
    and    rc.rate_class_type = p_rate_class_type
    and    rc.rate_class_id = nvl(x_rate_class_id,rc.rate_class_id);

Line: 66

      select parent_category
      into   l_parent_category
      from   igw_budget_expenditures_v
      where  budget_expenditure = p_expenditure_type
      and    expenditure_category_flag = p_expenditure_category_flag
      and    parent_category is not null;

Line: 114

        select  meaning
	into	l_activity_type
	from 	fnd_lookups
	where   lookup_type = 'IGW_ACTIVITY_TYPES'
  	and	lookup_code = p_activity_type_code;

Line: 122

        select  meaning
	into	l_location
	from 	fnd_lookups
	where   lookup_type = 'IGW_LOCATION'
  	and	lookup_code = p_location_code;

Line: 129

 	select  rc.description
	,	rt.description
	into	l_rate_class
	,	l_rate_type
	from	igw_rate_classes   rc
	,	igw_rate_types	    rt
	where	rc.rate_class_id = rt.rate_class_id
	and	rc.rate_class_id = p_rate_class_id
	and	rt.rate_type_id = p_rate_type_id;

Line: 140

          select rate,start_date
          into   x_rate, x_start_date
          from   igw_institute_rates 	ir
          where  ir.rate_class_id = p_rate_class_id
          and    ir.rate_type_id = p_rate_type_id
          and    ir.activity_type_code = p_activity_type_code
          and    ir.location_code = p_location_code
          and    ir.fiscal_year = p_fiscal_year;

Line: 153

          select   applicable_rate, start_date
          into 	   x_rate_ov, x_start_date
          from 	   igw_prop_rates
          where    rate_class_id = p_rate_class_id
          and      rate_type_id = p_rate_type_id
          and      activity_type_code = p_activity_type_code
          and      location_code = p_location_code
          and      fiscal_year = p_fiscal_year
  	  and 	   proposal_id = p_proposal_id
	  and	   version_id = p_version_id;

Line: 205

  select applicable_rate
  into   l_applicable_rate
  from   igw_prop_rates
  where  proposal_id = p_proposal_id
  and    version_id = p_version_id
  and    rate_class_id = p_rate_class_id
  and    rate_type_id = p_rate_type_id
  and    location_code = p_location_code
  and    activity_type_code = p_activity_type_code
  and    fiscal_year = p_fiscal_year;

Line: 753

    select rate,start_date, fiscal_year
    from   igw_institute_rates 	ir
    where  ir.rate_class_id = l_rate_class_id_inf
    and    ir.rate_type_id = l_rate_type_id_inf
    and    ir.activity_type_code = p_activity_type_code
    and    ir.location_code = p_location_code
    and    (ir.start_date > p_line_start_date and ir.start_date <= p_line_end_date);

Line: 970

          select   applicable_rate
          into 	   l_inflation_rate_ov
          from 	   igw_prop_rates
          where    rate_class_id = l_rate_class_id_inf
          and      rate_type_id = l_rate_type_id_inf
          and      activity_type_code = p_activity_type_code
          and      location_code = p_location_code
          and      fiscal_year = rec_inf_rates.fiscal_year
  	  and 	   proposal_id = p_proposal_id
	  and	   version_id = p_version_id;