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 42: FROM per_all_assignments_f ass,

38: ret_val hr_assignment_rec;
39: BEGIN
40: SELECT * INTO ret_val FROM (
41: SELECT p_person_id, effective_start_date, effective_end_date, grade_id, job_id, position_id
42: FROM per_all_assignments_f ass,
43: per_employees_x P
44: WHERE P.EMPLOYEE_ID = p_person_id
45: AND ass.person_id = P.employee_id
46: AND NOT AP_WEB_DB_HR_INT_PKG.isPersonCwk(P.employee_id)='Y'

Line 51: FROM per_all_assignments_f ass,

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

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

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

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

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

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

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