APPS.CNREDF_REPOSITORIES_PKG SQL Statements

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

Line: 17

      SELECT cn_repositories_s.nextval
	INTO X_repository_id
	FROM dual;

Line: 32

  PROCEDURE select_columns (X_application_type	    IN OUT	varchar2,
			    X_application_type_name IN OUT	varchar2) IS

  BEGIN

    SELECT meaning INTO X_application_type_name
      FROM cn_lookups
     WHERE lookup_code = X_application_type
       AND lookup_type = 'APPLICATION_TYPE';

Line: 42

  END select_columns;