The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select ELIGY_CRITERIA_ID, CRIT_COL1_DATATYPE,
CRITERIA_TYPE, ALLOW_RANGE_VALIDATION_FLAG,
CRIT_COL1_VAL_TYPE_CD,CRIT_COL2_DATATYPE,
ALLOW_RANGE_VALIDATION_FLAG2,CRIT_COL2_VAL_TYPE_CD
into p_criteria_id, P_CRIT_COL1_DATATYPE,
p_CRITERIA_TYPE, p_ALLOW_RANGE_VALIDATION_FLAG,
p_CRIT_COL1_VAL_TYPE_CD, P_CRIT_COL2_DATATYPE,
p_ALLOW_RANGE_VALIDATION_FLAG2,p_CRIT_COL2_VAL_TYPE_CD
from ben_eligy_criteria
where short_code = p_short_code
and business_group_id = p_business_group_id;
Select ELIGY_CRITERIA_ID, CRIT_COL1_DATATYPE,
CRITERIA_TYPE, ALLOW_RANGE_VALIDATION_FLAG,
CRIT_COL1_VAL_TYPE_CD,CRIT_COL2_DATATYPE,
ALLOW_RANGE_VALIDATION_FLAG2,CRIT_COL2_VAL_TYPE_CD
into p_criteria_id, P_CRIT_COL1_DATATYPE,
p_CRITERIA_TYPE, p_ALLOW_RANGE_VALIDATION_FLAG,
p_CRIT_COL1_VAL_TYPE_CD, P_CRIT_COL2_DATATYPE,
p_ALLOW_RANGE_VALIDATION_FLAG2,p_CRIT_COL2_VAL_TYPE_CD
from ben_eligy_criteria
where short_code = p_short_code
and business_group_id is null;