APPS.CNSYIN_REPOSITORY_PKG SQL Statements

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

Line: 11

  PROCEDURE select_columns (	X_repository_id IN OUT 		number,
				X_status	IN OUT		varchar2,
				X_status_name   IN OUT		varchar2,
				X_usage		IN OUT		varchar2,
				X_usage_name 	IN OUT		varchar2) IS

  BEGIN

    SELECT lookup1.meaning, lookup2.meaning
      INTO X_status_name, X_usage_name
      FROM cn_lookups lookup1, cn_lookups lookup2
     WHERE lookup1.lookup_type = 'REPOSITORY_STATUS'
       AND lookup1.lookup_code = X_status
       AND lookup2.lookup_type = 'REPOSITORY_USAGE'
       AND lookup2.lookup_code = X_usage;

Line: 32

  END select_columns;