APPS.EGO_CATG_MAP_UTIL_PKG SQL Statements

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

Line: 17

   SELECT
         catg_map_id, target_catg_id
   FROM EGO_CATG_MAP_DTLS
   WHERE source_catg_id = cp_category_id
   AND ROWNUM = 1;

Line: 25

   SELECT
         target_catg_set_id
   FROM EGO_CATG_MAP_HDRS_B
   WHERE catg_map_id = cp_catg_map_id;

Line: 59

   SELECT
         target_catg_id
   FROM EGO_CATG_MAP_DTLS det, EGO_CATG_MAP_HDRS_B hdr
   WHERE det.catg_map_id = hdr.catg_map_id
   AND source_catg_id = cp_category_id
   AND target_catg_set_id = -1
   AND ENABLED_FLAG = 'Y'
   AND ROWNUM = 1;

Line: 70

   SELECT CATEGORY_ID
   INTO l_category_id
   FROM mtl_categories_kfv
   WHERE SEGMENT2 = P_GPC_ID
   AND ROWNUM = 1;