31: position VARCHAR2(2000),
32: job_id PER_ALL_ASSIGNMENTS_F.job_id%TYPE,
33: job PER_JOBS.name%TYPE,
34: organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE,
35: organization HR_ORGANIZATION_UNITS.name%TYPE,
36: employment_category PER_ALL_ASSIGNMENTS_F.employment_category%TYPE,
37: employment_category_meaning FND_COMMON_LOOKUPS.meaning%TYPE
38: );
39:
38: );
39:
40: TYPE emp_pr_data_rec IS RECORD (
41: segment1 PA_PROJECTS.segment1%TYPE,
42: name HR_ORGANIZATION_UNITS.name%TYPE
43: );
44:
45: TYPE emp_tr_data_rec IS RECORD (
46: task_name PA_TASKS.task_name%TYPE