3: TYPE job_title_rec_type IS record
4: (job_title_id cn_job_titles.job_title_id%type,
5: name cn_job_titles.name%type,
6: job_code cn_job_titles.job_code%type,
7: role_id cn_roles.role_id%type,
8: role_name cn_roles.name%type);
9:
10: TYPE job_title_tbl_type IS table OF job_title_rec_type
11: INDEX BY binary_integer;
4: (job_title_id cn_job_titles.job_title_id%type,
5: name cn_job_titles.name%type,
6: job_code cn_job_titles.job_code%type,
7: role_id cn_roles.role_id%type,
8: role_name cn_roles.name%type);
9:
10: TYPE job_title_tbl_type IS table OF job_title_rec_type
11: INDEX BY binary_integer;
12: