APPS.FND_PLSQL_CACHE SQL Statements

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

Line: 493

   px_storage.DELETE;

Line: 633

   px_storage.DELETE;

Line: 1772

	   SELECT application_id, application_short_name, application_name
	     INTO l_application
	     FROM fnd_application_vl
	     WHERE application_short_name = p_application_short_name;

Line: 1834

	   SELECT application_id, application_short_name, application_name
	     INTO l_application
	     FROM fnd_application_vl
	     WHERE application_short_name = p_application_short_name;

Line: 1859

	     SELECT r.responsibility_id, r.responsibility_key, r.responsibility_name
	       FROM fnd_responsibility_vl r, fnd_application a
	       WHERE a.application_short_name = p_application_short_name
	       AND r.application_id = a.application_id;

Line: 1932

	     SELECT r.responsibility_id, r.responsibility_key, r.responsibility_name
	       FROM fnd_responsibility_vl r, fnd_application a
	       WHERE a.application_short_name = p_application_short_name
	       AND r.application_id = a.application_id;

Line: 2040

   g_app_custom_1to1_storage.DELETE;

Line: 2054

   g_rsp_custom_1tom_storage.DELETE;