[Home] [Help]
16:
17: SELECT trg.name, tab.name
18: INTO X_trigger_name, X_table_name
19: FROM cn_obj_triggers_v trg,
20: cn_obj_tables_v tab
21: WHERE trg.trigger_id = X_trigger_id
22: AND tab.table_id = trg.table_id;
23:
24: END select_columns;
89:
90: SELECT trg.table_id, tab.name
91: INTO X_table_id, X_table_name
92: FROM cn_obj_triggers_v trg,
93: cn_obj_tables_v tab
94: WHERE trg.trigger_id = X_trigger_id
95: AND tab.table_id = trg.table_id;
96:
97: END Get_Trigger_ID_Defaults;