APPS.CNREDF_TRIGGERS_PKG SQL Statements

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

Line: 11

  PROCEDURE select_columns(	X_table_id		IN OUT	number,
				X_triggering_event	IN OUT	varchar2,
				X_table_name		IN OUT	varchar2,
				X_event_name		IN OUT	varchar2) IS

  BEGIN

    IF X_table_ID is NOT NULL THEN

      SELECT name
        INTO X_table_name
        FROM cn_obj_tables_v
       WHERE table_id = X_table_id;

Line: 31

      SELECT meaning
        INTO X_event_name
        FROM cn_lookups
       WHERE lookup_code = X_triggering_event
	 AND lookup_type = 'TRIGGERING_EVENT';

Line: 41

  END select_columns;

Line: 56

      SELECT cn_objects_s.nextval
        INTO X_trigger_id FROM dual;