80: ,employment_category per_all_assignments_f.employment_category%TYPE
81: );
82:
83: TYPE r_lookup_code IS RECORD(
84: lookup_code hr_lookups.lookup_code%TYPE
85: ,meaning hr_lookups.meaning%TYPE
86: );
87:
88: -- cursor to fetch dated table info
81: );
82:
83: TYPE r_lookup_code IS RECORD(
84: lookup_code hr_lookups.lookup_code%TYPE
85: ,meaning hr_lookups.meaning%TYPE
86: );
87:
88: -- cursor to fetch dated table info
89: CURSOR csr_get_dated_table_info(c_table_name VARCHAR2)