APPS.PQH_RBC_ELPRO SQL Statements

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

Line: 19

 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;

Line: 36

      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;