[Home] [Help]
88: -- cursor to fetch dated table info
89: CURSOR csr_get_dated_table_info(c_table_name VARCHAR2)
90: IS
91: SELECT dated_table_id, table_name, surrogate_key_name
92: FROM pay_dated_tables
93: WHERE table_name = c_table_name;
94:
95: TYPE t_dated_table IS TABLE OF csr_get_dated_table_info%ROWTYPE
96: INDEX BY BINARY_INTEGER;