APPS.CN_GENERAL_UTILS SQL Statements

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

Line: 29

        select SET_OF_BOOKS_ID
        into    SOB_ID
        from    CN_REPOSITORIES;

Line: 46

   SELECT  s.currency_code
     INTO  x_currency_code
     FROM  gl_sets_of_books s
	  ,cn_repositories_all  r
    WHERE r.set_of_books_id = s.set_of_books_id
      AND r.application_id  = 283
      AND r.org_id = p_org_id
    ;

Line: 77

   SELECT  s.currency_code
     INTO  x_currency_code
     FROM  gl_sets_of_books s
	  ,cn_repositories  r
    WHERE r.set_of_books_id = s.set_of_books_id
      AND r.application_id  = 283
    ;

Line: 99

   SELECT period_id
   INTO   X_period_id
   FROM   cn_periods
   WHERE  X_period_date BETWEEN trunc(start_date)
                        AND trunc(end_date)
   ;

Line: 135

     SELECT  p.period_id
	    ,p.period_status
	    ,p.period_name
	    ,p.start_date
	    ,p.end_date
       INTO  x_period_id
	    ,x_period_status
	    ,x_period_name
	    ,x_start_date
	    ,x_end_date
       FROM cn_periods p
      WHERE (   x_period_date IS NULL
	     OR x_period_date  BETWEEN trunc(p.start_date)
             			   AND trunc(p.end_date) )
        AND (   x_period_name IS NULL
	     OR x_period_name = p.period_name)
        AND (   x_period_id IS NULL
	     OR x_period_id = p.period_id)
    ;

Line: 175

   SELECT period_name
   INTO   X_period_name
   FROM   cn_periods
   WHERE  period_id = X_period_id
   ;

Line: 202

    SELECT meaning
    INTO   X_meaning
    FROM   cn_lookups
    WHERE  lookup_code = X_lookup_code
    AND    lookup_type = X_lookup_type;

Line: 228

   SELECT  name
	  ,employee_number
   INTO   x_name
	 ,x_employee_number
   FROM   cn_salesreps
   WHERE  salesrep_id = X_Salesrep_id
   ;

Line: 252

  SELECT user_name
  INTO   X_username
  FROM   fnd_user
  WHERE  user_id = X_userid;