[Home] [Help]
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;