273: c.p1 is null then
274: L_GRADE_ID:=nn;
275: else
276: L_GRADE_ID :=
277: hr_pump_get.get_grade_id
278: (P_GRADE_NAME => c.p28
279: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
280: ,P_EFFECTIVE_DATE => c.p1);
281: end if;
284: c.p1 is null then
285: L_JOB_ID:=nn;
286: else
287: L_JOB_ID :=
288: hr_pump_get.get_job_id
289: (P_JOB_NAME => c.p29
290: ,P_EFFECTIVE_DATE => c.p1
291: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
292: end if;
295: c.p1 is null then
296: L_POSITION_ID:=nn;
297: else
298: L_POSITION_ID :=
299: hr_pump_get.get_position_id
300: (P_POSITION_NAME => c.p30
301: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
302: ,P_EFFECTIVE_DATE => c.p1);
303: end if;