14: g_as_of_date_4_loc_pubview DATE := NULL;
15: g_as_of_date_4_emp_pubview DATE := NULL;
16:
17: TYPE emp_hr_data_rec IS RECORD (
18: person_id PER_ALL_PEOPLE_F.person_id%TYPE,
19: effective_start_date PER_ALL_PEOPLE_F.effective_start_date%TYPE,
20: effective_end_date PER_ALL_PEOPLE_F.effective_end_date%TYPE,
21: assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE,
22: last_name PER_ALL_PEOPLE_F.last_name%TYPE,
15: g_as_of_date_4_emp_pubview DATE := NULL;
16:
17: TYPE emp_hr_data_rec IS RECORD (
18: person_id PER_ALL_PEOPLE_F.person_id%TYPE,
19: effective_start_date PER_ALL_PEOPLE_F.effective_start_date%TYPE,
20: effective_end_date PER_ALL_PEOPLE_F.effective_end_date%TYPE,
21: assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE,
22: last_name PER_ALL_PEOPLE_F.last_name%TYPE,
23: employee_number PER_ALL_PEOPLE_F.employee_number%TYPE,
16:
17: TYPE emp_hr_data_rec IS RECORD (
18: person_id PER_ALL_PEOPLE_F.person_id%TYPE,
19: effective_start_date PER_ALL_PEOPLE_F.effective_start_date%TYPE,
20: effective_end_date PER_ALL_PEOPLE_F.effective_end_date%TYPE,
21: assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE,
22: last_name PER_ALL_PEOPLE_F.last_name%TYPE,
23: employee_number PER_ALL_PEOPLE_F.employee_number%TYPE,
24: email_address PER_ALL_PEOPLE_F.email_address%TYPE,
18: person_id PER_ALL_PEOPLE_F.person_id%TYPE,
19: effective_start_date PER_ALL_PEOPLE_F.effective_start_date%TYPE,
20: effective_end_date PER_ALL_PEOPLE_F.effective_end_date%TYPE,
21: assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE,
22: last_name PER_ALL_PEOPLE_F.last_name%TYPE,
23: employee_number PER_ALL_PEOPLE_F.employee_number%TYPE,
24: email_address PER_ALL_PEOPLE_F.email_address%TYPE,
25: first_name PER_ALL_PEOPLE_F.first_name%TYPE,
26: full_name PER_ALL_PEOPLE_F.full_name%TYPE,
19: effective_start_date PER_ALL_PEOPLE_F.effective_start_date%TYPE,
20: effective_end_date PER_ALL_PEOPLE_F.effective_end_date%TYPE,
21: assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE,
22: last_name PER_ALL_PEOPLE_F.last_name%TYPE,
23: employee_number PER_ALL_PEOPLE_F.employee_number%TYPE,
24: email_address PER_ALL_PEOPLE_F.email_address%TYPE,
25: first_name PER_ALL_PEOPLE_F.first_name%TYPE,
26: full_name PER_ALL_PEOPLE_F.full_name%TYPE,
27: person_type_id PER_ALL_PEOPLE_F.person_type_id%TYPE,
20: effective_end_date PER_ALL_PEOPLE_F.effective_end_date%TYPE,
21: assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE,
22: last_name PER_ALL_PEOPLE_F.last_name%TYPE,
23: employee_number PER_ALL_PEOPLE_F.employee_number%TYPE,
24: email_address PER_ALL_PEOPLE_F.email_address%TYPE,
25: first_name PER_ALL_PEOPLE_F.first_name%TYPE,
26: full_name PER_ALL_PEOPLE_F.full_name%TYPE,
27: person_type_id PER_ALL_PEOPLE_F.person_type_id%TYPE,
28: employee_type PER_PERSON_TYPES_tl.user_person_type%TYPE,
21: assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE,
22: last_name PER_ALL_PEOPLE_F.last_name%TYPE,
23: employee_number PER_ALL_PEOPLE_F.employee_number%TYPE,
24: email_address PER_ALL_PEOPLE_F.email_address%TYPE,
25: first_name PER_ALL_PEOPLE_F.first_name%TYPE,
26: full_name PER_ALL_PEOPLE_F.full_name%TYPE,
27: person_type_id PER_ALL_PEOPLE_F.person_type_id%TYPE,
28: employee_type PER_PERSON_TYPES_tl.user_person_type%TYPE,
29: phone_number PER_PHONES.phone_number%TYPE,
22: last_name PER_ALL_PEOPLE_F.last_name%TYPE,
23: employee_number PER_ALL_PEOPLE_F.employee_number%TYPE,
24: email_address PER_ALL_PEOPLE_F.email_address%TYPE,
25: first_name PER_ALL_PEOPLE_F.first_name%TYPE,
26: full_name PER_ALL_PEOPLE_F.full_name%TYPE,
27: person_type_id PER_ALL_PEOPLE_F.person_type_id%TYPE,
28: employee_type PER_PERSON_TYPES_tl.user_person_type%TYPE,
29: phone_number PER_PHONES.phone_number%TYPE,
30: position_id PER_ALL_ASSIGNMENTS_F.position_id%TYPE,
23: employee_number PER_ALL_PEOPLE_F.employee_number%TYPE,
24: email_address PER_ALL_PEOPLE_F.email_address%TYPE,
25: first_name PER_ALL_PEOPLE_F.first_name%TYPE,
26: full_name PER_ALL_PEOPLE_F.full_name%TYPE,
27: person_type_id PER_ALL_PEOPLE_F.person_type_id%TYPE,
28: employee_type PER_PERSON_TYPES_tl.user_person_type%TYPE,
29: phone_number PER_PHONES.phone_number%TYPE,
30: position_id PER_ALL_ASSIGNMENTS_F.position_id%TYPE,
31: position VARCHAR2(2000),