DBA Data[Home] [Help]

APPS.PNP_UTIL_FUNC dependencies on PER_ALL_PEOPLE_F

Line 18: person_id PER_ALL_PEOPLE_F.person_id%TYPE,

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,

Line 19: effective_start_date PER_ALL_PEOPLE_F.effective_start_date%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,

Line 20: effective_end_date PER_ALL_PEOPLE_F.effective_end_date%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,

Line 22: last_name PER_ALL_PEOPLE_F.last_name%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,

Line 23: employee_number PER_ALL_PEOPLE_F.employee_number%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,

Line 24: email_address PER_ALL_PEOPLE_F.email_address%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,

Line 25: first_name PER_ALL_PEOPLE_F.first_name%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,

Line 26: full_name PER_ALL_PEOPLE_F.full_name%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,

Line 27: person_type_id PER_ALL_PEOPLE_F.person_type_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),