APPS.BIM_PRODUCT_CATEG_PKG SQL Statements

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

Line: 12

SELECT interest_code_id
  FROM bim_dimv_interest_codes
 WHERE interest_code = p_interest_code
   AND parent_interest_code_id is NULL
   AND interest_type_id = p_interest_type_id ;

Line: 21

SELECT interest_code_id
  FROM bim_dimv_interest_codes
 WHERE interest_code = p_interest_code
   AND parent_interest_code_id is NOT NULL
   AND interest_type_id = p_interest_type_id ;