APPS.CSM_SETUP_PROFILE SQL Statements

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

Line: 66

    SELECT  'X'
      FROM  mtl_categories_kfv mck,
            mtl_categories_vl mcv,
            mtl_category_sets_vl mcs
     WHERE mck.category_id = mcv.category_id
       AND mcv.enabled_flag = 'Y'
       AND NVL(mcv.disable_date, sysdate) >= SYSDATE
       AND mcs.category_set_id =  itemCatSet
       AND mcv.category_id = itemCat
       AND mcs.structure_id = mck.structure_id
       AND mcs.validate_flag = 'N'
    UNION
    SELECT 'X'
      FROM mtl_category_set_valid_cats valid_cat,
           mtl_categories_kfv mck,
           mtl_categories_vl mcv,
           mtl_category_sets_vl mcs
     WHERE valid_cat.category_set_id = mcs.category_set_id
       AND mcs.category_set_id = itemCatSet
       AND mck.category_id = itemCat
       AND  mcs.validate_flag = 'Y'
       AND  valid_cat.category_id = mck.category_id
       AND  mck.category_id = mcv.category_id
       AND  mcv.enabled_flag = 'Y'
       AND  NVL(mcv.disable_date, sysdate) >= SYSDATE ;

Line: 134

	select responsibility_id
	  into respId
          from fnd_responsibility
         where application_id = 883
	   and responsibility_key = 'OMFS_PALM'
	   and sysdate between start_date and nvl(end_date, sysdate) ;