APPS.PER_APPLICANT_PKG dependencies on HR_ALL_POSITIONS

Line 33: -- Changed 01-Oct-99 SCNair ( per_all_positions to hr_all_positions ) date track requirement

29: p_finish in out nocopy varchar2,
30: p_probation_period in out nocopy number,
31: p_probation_unit in out nocopy varchar2 ) is
32: --
33: -- Changed 01-Oct-99 SCNair ( per_all_positions to hr_all_positions ) date track requirement
34: --
35: cursor get_pos_conditions is
36: select p.working_hours,
37: p.frequency,

Line 42: from hr_all_positions p

38: p.time_normal_start,
39: p.time_normal_finish,
40: p.probation_period,
41: p.probation_period_unit_cd probation_period_units
42: from hr_all_positions p
43: where p.position_id = p_position_id ;
44: --
45: cursor get_org_conditions is
46: select fnd_number.canonical_to_number(o.working_hours),

Line 1790: -- Changed 01-Oct-99 SCNair (per_all_positions to hr_all_positions) date track requirement

1786: select x.name
1787: from per_jobs_vl x
1788: where x.job_id = p_job_id ;
1789: --
1790: -- Changed 01-Oct-99 SCNair (per_all_positions to hr_all_positions) date track requirement
1791: --
1792: cursor get_position is
1793: select x.name
1794: from hr_all_positions x

Line 1794: from hr_all_positions x

1790: -- Changed 01-Oct-99 SCNair (per_all_positions to hr_all_positions) date track requirement
1791: --
1792: cursor get_position is
1793: select x.name
1794: from hr_all_positions x
1795: where x.position_id = p_pos_id ;
1796: --
1797: cursor get_grade is
1798: select x.name

Line 2118: -- Changed 01-Oct-99 SCNair (per_all_positions to hr_all_positions) date track requirement.

2114: l_return_value boolean := FALSE ;
2115: l_dummy number ;
2116: l_proc varchar2(20) :='chk_job_org_pos_comb';
2117: --
2118: -- Changed 01-Oct-99 SCNair (per_all_positions to hr_all_positions) date track requirement.
2119: cursor c1 is
2120: SELECT 1
2121: FROM HR_ALL_POSITIONS P
2122: WHERE P.JOB_ID = p_job_id

Line 2121: FROM HR_ALL_POSITIONS P

2117: --
2118: -- Changed 01-Oct-99 SCNair (per_all_positions to hr_all_positions) date track requirement.
2119: cursor c1 is
2120: SELECT 1
2121: FROM HR_ALL_POSITIONS P
2122: WHERE P.JOB_ID = p_job_id
2123: AND P.ORGANIZATION_ID = p_org_id
2124: AND P.POSITION_ID = p_pos_id
2125: AND P.DATE_EFFECTIVE <= p_date_received