APPS.PNP_UTIL_FUNC dependencies on PER_ALL_ASSIGNMENTS_F

Line 21: assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE,

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

Line 30: position_id PER_ALL_ASSIGNMENTS_F.position_id%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),
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,

Line 32: job_id PER_ALL_ASSIGNMENTS_F.job_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),
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,

Line 34: organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE,

30: position_id PER_ALL_ASSIGNMENTS_F.position_id%TYPE,
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: );

Line 36: employment_category PER_ALL_ASSIGNMENTS_F.employment_category%TYPE,

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:
40: TYPE emp_pr_data_rec IS RECORD (