APPS.AZW_GROUP SQL Statements

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

Line: 31

	SELECT group_id
	FROM	az_groups
	WHERE
		hierarchy_parent_id = node_id
	AND	process_type = g_current_mode ;

Line: 43

	SELECT	count(*)
	INTO	child_count
	FROM	az_processes azp
	WHERE	azp.parent_id = node_id
	AND	azp.process_type = g_current_mode ;

Line: 56

	    fnd_message.set_token('AZW_ERROR_STMT','select count(*) into child_count from az_processes');

Line: 124

      SELECT   count(*)
      INTO     v_count_installed
      FROM     fnd_product_installations fpi, fnd_application_vl fav
      WHERE    fpi.application_id = fav.application_id
      AND      fav.application_id = v_appl_id
      AND      fpi.status = 'I';

Line: 150

	    fnd_message.set_token('AZW_ERROR_STMT','select status from fnd_product_installations,fnd_application_vl');

Line: 168

      SELECT   count(*)
      INTO     v_count_installed
      FROM     az_groups azg, fnd_product_installations fpi
      WHERE    fpi.application_id       = azg.application_id
      AND      fpi.status               = 'I'
      AND      azg.dependency_parent_id = p_group_id
      AND      process_type = g_current_mode;

Line: 220

      SELECT  group_id, dependency_parent_id, display_order,
              application_id, lookup_code, color_code, complete_flag
      FROM    az_groups
      WHERE   hierarchy_parent_id is null
      AND      process_type = g_current_mode
      ORDER BY 1;

Line: 338

		INSERT INTO az_webform_messages (mesg)
		  VALUES (mesg);

Line: 348

	    	fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');