APPS.PER_APPLICANT_PKG dependencies on HR_ALL_POSITIONS

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

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

Line 38: from hr_all_positions p

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

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

1550: select x.name
1551: from per_jobs_vl x
1552: where x.job_id = p_job_id ;
1553: --
1554: -- Changed 01-Oct-99 SCNair (per_all_positions to hr_all_positions) date track requirement
1555: --
1556: cursor get_position is
1557: select x.name
1558: from hr_all_positions x

Line 1558: from hr_all_positions x

1554: -- Changed 01-Oct-99 SCNair (per_all_positions to hr_all_positions) date track requirement
1555: --
1556: cursor get_position is
1557: select x.name
1558: from hr_all_positions x
1559: where x.position_id = p_pos_id ;
1560: --
1561: cursor get_grade is
1562: select x.name

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

1738: p_date_received in date ) return boolean is
1739: l_return_value boolean := FALSE ;
1740: l_dummy number ;
1741: --
1742: -- Changed 01-Oct-99 SCNair (per_all_positions to hr_all_positions) date track requirement.
1743: cursor c1 is
1744: SELECT 1
1745: FROM HR_ALL_POSITIONS P
1746: WHERE P.JOB_ID = p_job_id

Line 1745: FROM HR_ALL_POSITIONS P

1741: --
1742: -- Changed 01-Oct-99 SCNair (per_all_positions to hr_all_positions) date track requirement.
1743: cursor c1 is
1744: SELECT 1
1745: FROM HR_ALL_POSITIONS P
1746: WHERE P.JOB_ID = p_job_id
1747: AND P.ORGANIZATION_ID = p_org_id
1748: AND P.POSITION_ID = p_pos_id
1749: AND P.DATE_EFFECTIVE <= p_date_received