APPS.PER_SUC_BUS dependencies on HR_POSITIONS

Line 214: -- Changes 12-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked positions req.

210: l_proc varchar2(72) := g_package||'chk_position_id';
211: l_api_updating boolean;
212: l_dummy varchar2(1);
213: --
214: -- Changes 12-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked positions req.
215: --
216: cursor c1 is
217: select null
218: from hr_positions_f per

Line 218: from hr_positions_f per

214: -- Changes 12-Oct-99 SCNair (per_positions to hr_positions_f) Date tracked positions req.
215: --
216: cursor c1 is
217: select null
218: from hr_positions_f per
219: where per.position_id = nvl(p_position_id,-1)
220: and p_effective_date
221: between per.effective_start_date
222: and per.effective_end_date

Line 886: l_curr_position_id hr_positions.position_id%TYPE;

882:
883: procedure chk_person_start_date( p_person_id per_people_f.person_id%TYPE,
884: p_start_date per_assignments_f.effective_start_date%TYPE) IS
885:
886: l_curr_position_id hr_positions.position_id%TYPE;
887:
888: CURSOR person_start_details (p_person_id per_people_f.person_id%TYPE,p_start_date per_assignments_f.effective_start_date%TYPE) IS
889: SELECT paf.position_id
890: FROM per_assignments_f paf