APPS.AP_WEB_POLICY_UTILS dependencies on PER_EMPLOYEES_X

Line 7: TYPE hr_assignment_rec IS RECORD (person_id per_employees_x.employee_id%type,

3:
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,

Line 36: FUNCTION getHrAssignmentFromDB(p_person_id IN per_employees_x.employee_id%type,

32: | Date Author Description of Changes
33: | 21-Feb-2006 albowicz Created
34: |
35: *=======================================================================*/
36: FUNCTION getHrAssignmentFromDB(p_person_id IN per_employees_x.employee_id%type,
37: p_date IN DATE) RETURN hr_assignment_rec IS
38: ret_val hr_assignment_rec;
39: BEGIN
40: -- Bug: 8449406 -- Bug: 16283731

Line 44: per_employees_x P

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'
48: AND p_date >= effective_start_date and p_date <= effective_end_date

Line 82: FUNCTION getHrAssignment(p_person_id IN per_employees_x.employee_id%type,

78: | Date Author Description of Changes
79: | 21-Feb-2006 albowicz Created
80: |
81: *=======================================================================*/
82: FUNCTION getHrAssignment(p_person_id IN per_employees_x.employee_id%type,
83: p_date IN DATE) RETURN hr_assignment_rec IS
84: l_ret_val hr_assignment_rec;
85: l_temp hr_assignment_rec;
86: l_index INTEGER;

Line 139: PROCEDURE getHrAssignment(p_person_id IN per_employees_x.employee_id%type,

135: | 22-Feb-2006 albowicz Created
136: |
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