APPS.PER_ABSENCE_ATTENDANCES_PKG dependencies on HR_POSITIONS_F
Line 1910: from hr_positions_f pp,
1906: -- Changed 12-Oct-99 SCNair (per_positions to hr_positions) Date tracked position req.
1907: --
1908: cursor c4 is
1909: select 1 1910: from hr_positions_f pp, 1911: per_assignments_f asg
1912: where asg.person_id = p_psn_id
1913: and nvl(p_dstart,nvl(p_proj_start,p_sess)) between
1914: asg.effective_start_date and asg.effective_end_date