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: SELECT * INTO ret_val FROM (

Line 43: per_employees_x P

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

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

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

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

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