APPS.AP_WEB_POLICY_UTILS dependencies on PER_ALL_ASSIGNMENTS_F

Line 8: eff_start_date per_all_assignments_f.effective_start_date%type,

4: -- Max Length for Policy Schedule Name and Policy Schedule Period Name
5: C_PolicyNameMaxLength CONSTANT NUMBER := 60;
6:
7: TYPE hr_assignment_rec IS RECORD (person_id per_employees_x.employee_id%type,
8: eff_start_date per_all_assignments_f.effective_start_date%type,
9: eff_end_date per_all_assignments_f.effective_end_date%type,
10: grade_id per_all_assignments_f.grade_id%type,
11: job_id per_all_assignments_f.job_id%type,
12: position_id per_all_assignments_f.position_id%type);

Line 9: eff_end_date per_all_assignments_f.effective_end_date%type,

5: C_PolicyNameMaxLength CONSTANT NUMBER := 60;
6:
7: TYPE hr_assignment_rec IS RECORD (person_id per_employees_x.employee_id%type,
8: eff_start_date per_all_assignments_f.effective_start_date%type,
9: eff_end_date per_all_assignments_f.effective_end_date%type,
10: grade_id per_all_assignments_f.grade_id%type,
11: job_id per_all_assignments_f.job_id%type,
12: position_id per_all_assignments_f.position_id%type);
13:

Line 10: grade_id per_all_assignments_f.grade_id%type,

6:
7: TYPE hr_assignment_rec IS RECORD (person_id per_employees_x.employee_id%type,
8: eff_start_date per_all_assignments_f.effective_start_date%type,
9: eff_end_date per_all_assignments_f.effective_end_date%type,
10: grade_id per_all_assignments_f.grade_id%type,
11: job_id per_all_assignments_f.job_id%type,
12: position_id per_all_assignments_f.position_id%type);
13:
14: TYPE hr_assignment_cache_type IS TABLE OF hr_assignment_rec;

Line 11: job_id per_all_assignments_f.job_id%type,

7: TYPE hr_assignment_rec IS RECORD (person_id per_employees_x.employee_id%type,
8: eff_start_date per_all_assignments_f.effective_start_date%type,
9: eff_end_date per_all_assignments_f.effective_end_date%type,
10: grade_id per_all_assignments_f.grade_id%type,
11: job_id per_all_assignments_f.job_id%type,
12: position_id per_all_assignments_f.position_id%type);
13:
14: TYPE hr_assignment_cache_type IS TABLE OF hr_assignment_rec;
15: hr_assignment_cache hr_assignment_cache_type;

Line 12: position_id per_all_assignments_f.position_id%type);

8: eff_start_date per_all_assignments_f.effective_start_date%type,
9: eff_end_date per_all_assignments_f.effective_end_date%type,
10: grade_id per_all_assignments_f.grade_id%type,
11: job_id per_all_assignments_f.job_id%type,
12: position_id per_all_assignments_f.position_id%type);
13:
14: TYPE hr_assignment_cache_type IS TABLE OF hr_assignment_rec;
15: hr_assignment_cache hr_assignment_cache_type;
16:

Line 43: FROM per_all_assignments_f ass,

39: BEGIN
40: -- Bug: 8449406 -- Bug: 16283731
41: SELECT * INTO ret_val FROM (
42: SELECT p_person_id, effective_start_date, effective_end_date, grade_id, job_id, position_id
43: FROM per_all_assignments_f ass,
44: per_employees_x P
45: WHERE P.EMPLOYEE_ID = p_person_id
46: AND ass.assignment_id = P.assignment_id
47: AND NOT AP_WEB_DB_HR_INT_PKG.isPersonCwk(P.employee_id)='Y'

Line 52: FROM per_all_assignments_f ass,

48: AND p_date >= effective_start_date and p_date <= effective_end_date
49: AND ass.assignment_type = 'E'
50: UNION ALL
51: SELECT p_person_id, effective_start_date, effective_end_date, grade_id, job_id, position_id
52: FROM per_all_assignments_f ass,
53: per_cont_workers_x P
54: WHERE P.PERSON_ID = p_person_id
55: AND ass.assignment_id = p.assignment_id
56: AND p_date >= effective_start_date and p_date <= effective_end_date

Line 141: p_grade_id OUT NOCOPY per_all_assignments_f.grade_id%type,

137: *=======================================================================*/
138:
139: PROCEDURE getHrAssignment(p_person_id IN per_employees_x.employee_id%type,
140: p_date IN DATE,
141: p_grade_id OUT NOCOPY per_all_assignments_f.grade_id%type,
142: p_position_id OUT NOCOPY per_all_assignments_f.position_id%type,
143: p_job_id OUT NOCOPY per_all_assignments_f.job_id%type) IS
144:
145: l_hr_assignment hr_assignment_rec;

Line 142: p_position_id OUT NOCOPY per_all_assignments_f.position_id%type,

138:
139: PROCEDURE getHrAssignment(p_person_id IN per_employees_x.employee_id%type,
140: p_date IN DATE,
141: p_grade_id OUT NOCOPY per_all_assignments_f.grade_id%type,
142: p_position_id OUT NOCOPY per_all_assignments_f.position_id%type,
143: p_job_id OUT NOCOPY per_all_assignments_f.job_id%type) IS
144:
145: l_hr_assignment hr_assignment_rec;
146: BEGIN

Line 143: p_job_id OUT NOCOPY per_all_assignments_f.job_id%type) IS

139: PROCEDURE getHrAssignment(p_person_id IN per_employees_x.employee_id%type,
140: p_date IN DATE,
141: p_grade_id OUT NOCOPY per_all_assignments_f.grade_id%type,
142: p_position_id OUT NOCOPY per_all_assignments_f.position_id%type,
143: p_job_id OUT NOCOPY per_all_assignments_f.job_id%type) IS
144:
145: l_hr_assignment hr_assignment_rec;
146: BEGIN
147: