APPS.PQH_TENURE_DETAIL dependencies on PER_JOBS

Line 152: l_job_name per_jobs.name%type;

148:
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;