APPS.PQH_TENURE_DETAIL dependencies on HR_ALL_POSITIONS_F

Line 153: l_position_name hr_all_positions_f.name%type;

149: l_assignment_id number;
150: l_job_id number;
151: l_position_id number;
152: l_job_name per_jobs.name%type;
153: l_position_name hr_all_positions_f.name%type;
154: BEGIN
155: -- fetch the primary assignment
156: OPEN prim_asg;
157: FETCH prim_asg INTO l_assignment_id,l_job_id,l_position_id;