282: l.pval026 d26,
283: decode(l.pval027,cn,vn,vn,vn,l.pval027) p27,
284: l.pval027 d27,
285: decode(l.pval028,cn,vn,
286: hr_pump_get.gl(l.pval028,'AU_AUST_RES_SENR_AUS',dn,vn)) p28,
287: decode(l.pval029,cn,vn,
288: hr_pump_get.gl(l.pval029,'YES_NO',dn,vn)) p29,
289: decode(l.pval030,cn,nn,vn,nn,n(l.pval030)) p30,
290: l.pval030 d30,
284: l.pval027 d27,
285: decode(l.pval028,cn,vn,
286: hr_pump_get.gl(l.pval028,'AU_AUST_RES_SENR_AUS',dn,vn)) p28,
287: decode(l.pval029,cn,vn,
288: hr_pump_get.gl(l.pval029,'YES_NO',dn,vn)) p29,
289: decode(l.pval030,cn,nn,vn,nn,n(l.pval030)) p30,
290: l.pval030 d30,
291: decode(l.pval031,cn,vn,
292: hr_pump_get.gl(l.pval031,'HR_AU_FTA_PAYMENT_BASIS',dn,vn)) p31,
288: hr_pump_get.gl(l.pval029,'YES_NO',dn,vn)) p29,
289: decode(l.pval030,cn,nn,vn,nn,n(l.pval030)) p30,
290: l.pval030 d30,
291: decode(l.pval031,cn,vn,
292: hr_pump_get.gl(l.pval031,'HR_AU_FTA_PAYMENT_BASIS',dn,vn)) p31,
293: decode(l.pval032,cn,vn,
294: hr_pump_get.gl(l.pval032,'YES_NO',dn,vn)) p32,
295: decode(l.pval033,cn,vn,
296: hr_pump_get.gl(l.pval033,'AU_HECS_SFSS',dn,vn)) p33,
290: l.pval030 d30,
291: decode(l.pval031,cn,vn,
292: hr_pump_get.gl(l.pval031,'HR_AU_FTA_PAYMENT_BASIS',dn,vn)) p31,
293: decode(l.pval032,cn,vn,
294: hr_pump_get.gl(l.pval032,'YES_NO',dn,vn)) p32,
295: decode(l.pval033,cn,vn,
296: hr_pump_get.gl(l.pval033,'AU_HECS_SFSS',dn,vn)) p33,
297: decode(l.pval034,cn,vn,l.pval034) p34,
298: decode(l.pval035,cn,vn,
292: hr_pump_get.gl(l.pval031,'HR_AU_FTA_PAYMENT_BASIS',dn,vn)) p31,
293: decode(l.pval032,cn,vn,
294: hr_pump_get.gl(l.pval032,'YES_NO',dn,vn)) p32,
295: decode(l.pval033,cn,vn,
296: hr_pump_get.gl(l.pval033,'AU_HECS_SFSS',dn,vn)) p33,
297: decode(l.pval034,cn,vn,l.pval034) p34,
298: decode(l.pval035,cn,vn,
299: hr_pump_get.gl(l.pval035,'AU_MED_LEV_VAR',dn,vn)) p35,
300: decode(l.pval036,cn,vn,
295: decode(l.pval033,cn,vn,
296: hr_pump_get.gl(l.pval033,'AU_HECS_SFSS',dn,vn)) p33,
297: decode(l.pval034,cn,vn,l.pval034) p34,
298: decode(l.pval035,cn,vn,
299: hr_pump_get.gl(l.pval035,'AU_MED_LEV_VAR',dn,vn)) p35,
300: decode(l.pval036,cn,vn,
301: hr_pump_get.gl(l.pval036,'AU_SPOUSE_MLS',dn,vn)) p36,
302: decode(l.pval037,cn,vn,vn,vn,l.pval037) p37,
303: l.pval037 d37,
297: decode(l.pval034,cn,vn,l.pval034) p34,
298: decode(l.pval035,cn,vn,
299: hr_pump_get.gl(l.pval035,'AU_MED_LEV_VAR',dn,vn)) p35,
300: decode(l.pval036,cn,vn,
301: hr_pump_get.gl(l.pval036,'AU_SPOUSE_MLS',dn,vn)) p36,
302: decode(l.pval037,cn,vn,vn,vn,l.pval037) p37,
303: l.pval037 d37,
304: decode(l.pval038,cn,vn,l.pval038) p38,
305: decode(l.pval039,cn,nn,vn,nn,n(l.pval039)) p39,
330: if c.p42 is null then
331: L_ASSIGNMENT_ID:=nn;
332: else
333: L_ASSIGNMENT_ID :=
334: hr_pump_get.get_assignment_id
335: (P_ASSIGNMENT_USER_KEY => c.p42);
336: end if;
337: --
338: hr_data_pump.api_trc_on;