APPS.CN_UPGRADE_UTL_PKG SQL Statements

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

Line: 11

	SELECT start_date
	  FROM cn_period_statuses_all
	  WHERE period_id = p_period_id
	  AND ((org_id = p_org_id) OR (org_id IS NULL AND p_org_id IS NULL));

Line: 42

	SELECT end_date
	  FROM cn_period_statuses_all
	  WHERE period_id = p_period_id
	  AND ((org_id = p_org_id) OR (org_id IS NULL AND p_org_id IS NULL));

Line: 79

   SELECT profile_option_value
   from   fnd_profile_option_values
   where  profile_option_id =
     (select profile_option_id
      from   fnd_profile_options
      where  upper(profile_option_name) = 'CN_UPGRADING_FROM_RELEASE'
      and    application_id = 283)
   and    level_id = 10001
   and    application_id = 283;

Line: 131

   SELECT profile_option_value
   from   fnd_profile_option_values
   where  profile_option_id =
     (select profile_option_id
      from   fnd_profile_options
      where  upper(profile_option_name) = 'CN_UPGRADING_FROM_RELEASE'
      and    application_id = 283)
   and    level_id = 10001
   and    application_id = 283;

Line: 183

   SELECT profile_option_value
   from   fnd_profile_option_values
   where  profile_option_id =
     (select profile_option_id
      from   fnd_profile_options
      where  upper(profile_option_name) = 'CN_UPGRADING_FROM_RELEASE'
      and    application_id = 283)
   and    level_id = 10001
   and    application_id = 283;

Line: 235

   SELECT profile_option_value
   from   fnd_profile_option_values
   where  profile_option_id =
     (select profile_option_id
      from   fnd_profile_options
      where  upper(profile_option_name) = 'CN_UPGRADING_FROM_RELEASE'
      and    application_id = 283)
   and    level_id = 10001
   and    application_id = 283;

Line: 287

   SELECT profile_option_value
   from   fnd_profile_option_values
   where  profile_option_id =
     (select profile_option_id
      from   fnd_profile_options
      where  upper(profile_option_name) = 'CN_UPGRADING_FROM_RELEASE'
      and    application_id = 283)
   and    level_id = 10001
   and    application_id = 283;

Line: 332

   SELECT profile_option_value
   from   fnd_profile_option_values
   where  profile_option_id =
     (select profile_option_id
      from   fnd_profile_options
      where  upper(profile_option_name) = 'CN_UPGRADING_FROM_RELEASE'
      and    application_id = 283)
   and    level_id = 10001
   and    application_id = 283;