APPS.IGW_PROP_RATES_PVT SQL Statements

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

Line: 25

  select rowid
  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: 55

        igw_prop_rates_tbh.insert_row(
	  p_proposal_id           => p_proposal_id
  	  ,p_version_id           => p_version_id
	  ,p_rate_class_id        => p_rate_class_id
	  ,p_rate_type_id         => p_rate_type_id
	  ,p_fiscal_year          => to_char(p_fiscal_year)
	  ,p_location_code        => p_location_code
	  ,p_activity_type_code   => p_activity_type_code
	  ,p_start_date           => p_start_date
	  ,p_applicable_rate      => p_applicable_rate
	  ,p_institute_rate       => p_institute_rate
          ,x_rowid                => p_rowid
          ,x_return_status        => l_return_status);

Line: 71

        igw_prop_rates_tbh.update_row(
	  p_proposal_id           => p_proposal_id
  	  ,p_version_id           => p_version_id
	  ,p_rate_class_id        => p_rate_class_id
	  ,p_rate_type_id         => p_rate_type_id
	  ,p_fiscal_year          => to_char(p_fiscal_year)
	  ,p_location_code        => p_location_code
	  ,p_activity_type_code   => p_activity_type_code
	  ,p_start_date           => p_start_date
	  ,p_applicable_rate      => p_applicable_rate
	  ,p_institute_rate       => p_institute_rate
          ,p_rowid                => p_rowid
          ,p_record_version_number =>p_record_version_number
          ,x_return_status        => l_return_status);