APPS.AD_PA_VALIDATE_CRITERIASET SQL Statements

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

Line: 12

   select count(1) into l_count from AD_PA_CRITERIA
     where advisor_criteria_id = LTRIM(RTRIM((p_advisor_criteria_id)));

Line: 37

	  SELECT
	      bug_number
	     FROM
	      ad_bugs ab,
	      ad_comprising_patches acp
	     WHERE
	      ab.bug_id   = acp.bug_id  and
	      acp.patch_driver_id = p_patch_driver_id;

Line: 95

  select patch_level
  from   ad_patch_driver_minipks
  where  patch_driver_id = p_patch_driver_id;

Line: 142

  select count(*) into l_number from
  ad_program_run_task_jobs prtj,
  ad_files ldr_f,
  ad_files f,
  ad_patch_common_actions pca,
  ad_patch_run_bug_actions prba
where prba.action_id = p_action_id
and prba.common_action_id = pca.common_action_id
and prba.file_id = f.file_id
and pca.loader_data_file_id = ldr_f.file_id (+)
and nvl(ldr_f.filename, f.filename) = prtj.job_name
and UPPER(nvl(ldr_f.app_short_name, f.app_short_name)) = UPPER(prtj.product)
and nvl(prtj.arguments,'NA') = nvl(pca.action_arguments,'NA') -- Bug# (3443373)-KKS
and prtj.program_run_id = p_program_run_id
and prtj.session_id = p_session_id
and prtj.phase_name=pca.action_phase
and (pca.ACTION_ARGUMENTS is not null or
     pca.ACTION_WHAT_SQL_EXEC is not null or
     pca.ACTION_CHECK_OBJ_USERNAME is not null or
     pca.ACTION_CHECK_OBJ is not null or
     pca.ACTION_CHECK_OBJ_PASSWD is not null or
     prtj.start_time is not null or
     prtj.restart_time is not null or
     prtj.end_time is not null or
     prtj.restart_count is not null or
     prtj.elapsed_time  is not null ) ;

Line: 181

  select product_name
  from  ad_pm_prod_family_map appfm, ad_pm_product_info appi
  where appfm.product_family_abbreviation = appi.product_abbreviation
  and   appfm.product_abbreviation = l_product_abbr;

Line: 204

  select product_family_abbreviation
  from  ad_pm_prod_family_map appfm
  where appfm.product_abbreviation = l_product_abbr;