APPS.CNSYIN_COLLECTIONS_PKG SQL Statements

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

Line: 18

      SELECT cn_modules_s.nextval
        INTO X_module_id
	FROM dual;

Line: 35

  PROCEDURE select_columns (	X_event_id	IN 		number,
				X_event_name	IN OUT 		varchar2) IS

  BEGIN

    SELECT name
      INTO X_event_name
      FROM cn_events
     WHERE event_id = X_event_id;

Line: 49

  END select_columns;

Line: 68

    SELECT rr.schema, rr.application_type, rr.description,
	   rr.version, rr.status, rr.repository_id
      INTO X_schema, X_application_type, X_description, X_version,
	   X_status, X_repository_id
      FROM cn_repositories rr, cn_events re
     WHERE rr.repository_id = re.application_repository_id
       AND re.event_id = X_event_id;