APPS.POS_URL_PKG SQL Statements

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

Line: 104

  SELECT item_type,
         item_key
  FROM   wf_item_activity_statuses
  WHERE  notification_id  = p_ntf_id;

Line: 110

  SELECT SUBSTR(context,1,INSTR(context,':',1)-1),
         SUBSTR(context,INSTR(context,':')+1,
                       (INSTR(context,':',1,2) - INSTR(context,':')-1))
  FROM   wf_notifications
  WHERE  notification_id   = p_ntf_id;

Line: 198

	SELECT fpov.profile_option_value
	  FROM fnd_profile_options fpo,
	  fnd_profile_option_values fpov
	  WHERE fpo.application_id = 0
	  AND fpo.profile_option_name = 'APPS_SERVLET_AGENT'
	  AND fpo.profile_option_id = fpov.profile_option_id
	  AND fpov.level_id = 10001
	  AND fpov.application_id = 0;