[Home] [Help]
293: cursor cr is
294: select l.rowid myrowid,
295: decode(l.pval001,cn,dn,d(l.pval001)) p1,
296: decode(l.pval002,cn,vn,vn,vh,
297: hr_pump_get.gl(l.pval002,'CONTACT',d(l.pval001),vn)) p2,
298: l.pval002 d2,
299: l.plongval plongval,
300: decode(l.pval004,cn,vn,vn,'N',
301: hr_pump_get.gl(l.pval004,'YES_NO',d(l.pval001),vn)) p4,
297: hr_pump_get.gl(l.pval002,'CONTACT',d(l.pval001),vn)) p2,
298: l.pval002 d2,
299: l.plongval plongval,
300: decode(l.pval004,cn,vn,vn,'N',
301: hr_pump_get.gl(l.pval004,'YES_NO',d(l.pval001),vn)) p4,
302: l.pval004 d4,
303: decode(l.pval005,cn,vn,vn,'N',
304: hr_pump_get.gl(l.pval005,'YES_NO',d(l.pval001),vn)) p5,
305: l.pval005 d5,
300: decode(l.pval004,cn,vn,vn,'N',
301: hr_pump_get.gl(l.pval004,'YES_NO',d(l.pval001),vn)) p4,
302: l.pval004 d4,
303: decode(l.pval005,cn,vn,vn,'N',
304: hr_pump_get.gl(l.pval005,'YES_NO',d(l.pval001),vn)) p5,
305: l.pval005 d5,
306: decode(l.pval006,cn,vn,vn,'N',
307: hr_pump_get.gl(l.pval006,'YES_NO',d(l.pval001),vn)) p6,
308: l.pval006 d6,
303: decode(l.pval005,cn,vn,vn,'N',
304: hr_pump_get.gl(l.pval005,'YES_NO',d(l.pval001),vn)) p5,
305: l.pval005 d5,
306: decode(l.pval006,cn,vn,vn,'N',
307: hr_pump_get.gl(l.pval006,'YES_NO',d(l.pval001),vn)) p6,
308: l.pval006 d6,
309: decode(l.pval007,cn,dn,vn,dh,d(l.pval007)) p7,
310: l.pval007 d7,
311: decode(l.pval008,cn,dn,vn,dh,d(l.pval008)) p8,
310: l.pval007 d7,
311: decode(l.pval008,cn,dn,vn,dh,d(l.pval008)) p8,
312: l.pval008 d8,
313: decode(l.pval009,cn,vn,vn,'N',
314: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),vn)) p9,
315: l.pval009 d9,
316: decode(l.pval010,cn,vn,vn,'N',
317: hr_pump_get.gl(l.pval010,'YES_NO',d(l.pval001),vn)) p10,
318: l.pval010 d10,
313: decode(l.pval009,cn,vn,vn,'N',
314: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),vn)) p9,
315: l.pval009 d9,
316: decode(l.pval010,cn,vn,vn,'N',
317: hr_pump_get.gl(l.pval010,'YES_NO',d(l.pval001),vn)) p10,
318: l.pval010 d10,
319: decode(l.pval011,cn,nn,vn,nh,n(l.pval011)) p11,
320: l.pval011 d11,
321: decode(l.pval012,cn,vn,vn,'N',
318: l.pval010 d10,
319: decode(l.pval011,cn,nn,vn,nh,n(l.pval011)) p11,
320: l.pval011 d11,
321: decode(l.pval012,cn,vn,vn,'N',
322: hr_pump_get.gl(l.pval012,'YES_NO',d(l.pval001),vn)) p12,
323: l.pval012 d12,
324: decode(l.pval013,cn,vn,vn,'N',
325: hr_pump_get.gl(l.pval013,'YES_NO',d(l.pval001),vn)) p13,
326: l.pval013 d13,
321: decode(l.pval012,cn,vn,vn,'N',
322: hr_pump_get.gl(l.pval012,'YES_NO',d(l.pval001),vn)) p12,
323: l.pval012 d12,
324: decode(l.pval013,cn,vn,vn,'N',
325: hr_pump_get.gl(l.pval013,'YES_NO',d(l.pval001),vn)) p13,
326: l.pval013 d13,
327: decode(l.pval014,cn,vn,vn,vh,l.pval014) p14,
328: l.pval014 d14,
329: decode(l.pval015,cn,vn,vn,vh,l.pval015) p15,
446: c.p58 is null then
447: L_CONTACT_RELATIONSHIP_ID:=nn;
448: else
449: L_CONTACT_RELATIONSHIP_ID :=
450: hr_pump_get.get_contact_relationship_id
451: (P_CONTACT_USER_KEY => c.p57
452: ,P_CONTACTEE_USER_KEY => c.p58);
453: end if;
454: --
458: elsif c.d59 is null then
459: L_START_LIFE_REASON_ID:=nh;
460: else
461: L_START_LIFE_REASON_ID :=
462: hr_pump_get.get_start_life_reason_id
463: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
464: ,P_EFFECTIVE_DATE => c.p1
465: ,P_START_LIFE_REASON => c.p59);
466: end if;
471: elsif c.d60 is null then
472: L_END_LIFE_REASON_ID:=nh;
473: else
474: L_END_LIFE_REASON_ID :=
475: hr_pump_get.get_end_life_reason_id
476: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
477: ,P_EFFECTIVE_DATE => c.p1
478: ,P_END_LIFE_REASON => c.p60);
479: end if;