APPS.PA_RBS_PREC_PUB SQL Statements

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

Line: 27

  select resource_class_flag   -- cbs change
  into l_resource_class_flag
  from pa_rbs_versions_b
  where rbs_version_id = PA_RBS_PREC_PUB.g_rbs_version_id;

Line: 133

  select res_type_id, rc_prec_id, rc_prec_id, rc_prec_id, rc_prec_id
  bulk collect into res_type_rec_t
  from PA_PRL_RBS_PRECEDENCE;

Line: 188

  select resource_class_flag   -- cbs change
  into l_resource_class_flag
  from pa_rbs_versions_b
  where rbs_version_id = PA_RBS_PREC_PUB.g_rbs_version_id;

Line: 294

  select rule_type, rc_prec_id, rc_prec_id, rc_prec_id, rc_prec_id
  bulk collect into res_type_rec_t
  from PA_ACT_RBS_PRECEDENCE;