[Home] [Help]
390: select l.rowid myrowid,
391: decode(l.pval001,cn,dn,d(l.pval001)) p1,
392: decode(l.pval002,cn,vn,l.pval002) p2,
393: decode(l.pval003,cn,vn,vn,vn,
394: hr_pump_get.gl(l.pval003,'SEX',d(l.pval001),l.pval101)) p3,
395: l.pval003 d3,
396: decode(l.pval004,cn,vn,l.pval004) p4,
397: decode(l.pval005,cn,vn,vn,vn,l.pval005) p5,
398: l.pval005 d5,
402: l.pval007 d7,
403: decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
404: l.pval008 d8,
405: decode(l.pval009,cn,vn,vn,vn,
406: hr_pump_get.gl(l.pval009,'HOME_OFFICE',d(l.pval001),l.pval101)) p9,
407: l.pval009 d9,
408: decode(l.pval010,cn,vn,vn,vn,l.pval010) p10,
409: l.pval010 d10,
410: decode(l.pval011,cn,vn,vn,vn,l.pval011) p11,
409: l.pval010 d10,
410: decode(l.pval011,cn,vn,vn,vn,l.pval011) p11,
411: l.pval011 d11,
412: decode(l.pval012,cn,vn,vn,vn,
413: hr_pump_get.gl(l.pval012,'MAR_STATUS',d(l.pval001),l.pval101)) p12,
414: l.pval012 d12,
415: decode(l.pval013,cn,vn,vn,vn,l.pval013) p13,
416: l.pval013 d13,
417: decode(l.pval014,cn,vn,vn,vn,
414: l.pval012 d12,
415: decode(l.pval013,cn,vn,vn,vn,l.pval013) p13,
416: l.pval013 d13,
417: decode(l.pval014,cn,vn,vn,vn,
418: hr_pump_get.gl(l.pval014,'NATIONALITY',d(l.pval001),l.pval101)) p14,
419: l.pval014 d14,
420: decode(l.pval015,cn,vn,vn,vn,l.pval015) p15,
421: l.pval015 d15,
422: decode(l.pval016,cn,vn,vn,vn,l.pval016) p16,
421: l.pval015 d15,
422: decode(l.pval016,cn,vn,vn,vn,l.pval016) p16,
423: l.pval016 d16,
424: decode(l.pval017,cn,vn,vn,vn,
425: hr_pump_get.gl(l.pval017,'REGISTERED_DISABLED',d(l.pval001),l.pval101)) p17,
426: l.pval017 d17,
427: decode(l.pval018,cn,vn,vn,vn,
428: hr_pump_get.gl(l.pval018,'TITLE',d(l.pval001),l.pval101)) p18,
429: l.pval018 d18,
424: decode(l.pval017,cn,vn,vn,vn,
425: hr_pump_get.gl(l.pval017,'REGISTERED_DISABLED',d(l.pval001),l.pval101)) p17,
426: l.pval017 d17,
427: decode(l.pval018,cn,vn,vn,vn,
428: hr_pump_get.gl(l.pval018,'TITLE',d(l.pval001),l.pval101)) p18,
429: l.pval018 d18,
430: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,
431: l.pval019 d19,
432: decode(l.pval020,cn,vn,vn,vn,l.pval020) p20,
491: l.pval049 d49,
492: decode(l.pval050,cn,vn,vn,vn,l.pval050) p50,
493: l.pval050 d50,
494: decode(l.pval051,cn,vn,vn,vn,
495: hr_pump_get.gl(l.pval051,'US_ETHNIC_GROUP',d(l.pval001),l.pval101)) p51,
496: l.pval051 d51,
497: decode(l.pval052,cn,vn,vn,'N',
498: hr_pump_get.gl(l.pval052,'PER_US_I9_STATE',d(l.pval001),l.pval101)) p52,
499: l.pval052 d52,
494: decode(l.pval051,cn,vn,vn,vn,
495: hr_pump_get.gl(l.pval051,'US_ETHNIC_GROUP',d(l.pval001),l.pval101)) p51,
496: l.pval051 d51,
497: decode(l.pval052,cn,vn,vn,'N',
498: hr_pump_get.gl(l.pval052,'PER_US_I9_STATE',d(l.pval001),l.pval101)) p52,
499: l.pval052 d52,
500: decode(l.pval053,cn,vn,vn,vn,l.pval053) p53,
501: l.pval053 d53,
502: decode(l.pval054,cn,vn,vn,vn,
499: l.pval052 d52,
500: decode(l.pval053,cn,vn,vn,vn,l.pval053) p53,
501: l.pval053 d53,
502: decode(l.pval054,cn,vn,vn,vn,
503: hr_pump_get.gl(l.pval054,'US_VETERAN_STATUS',d(l.pval001),l.pval101)) p54,
504: l.pval054 d54,
505: decode(l.pval055,cn,vn,vn,vn,
506: hr_pump_get.gl(l.pval055,'US_NEW_HIRE_STATUS',d(l.pval001),l.pval101)) p55,
507: l.pval055 d55,
502: decode(l.pval054,cn,vn,vn,vn,
503: hr_pump_get.gl(l.pval054,'US_VETERAN_STATUS',d(l.pval001),l.pval101)) p54,
504: l.pval054 d54,
505: decode(l.pval055,cn,vn,vn,vn,
506: hr_pump_get.gl(l.pval055,'US_NEW_HIRE_STATUS',d(l.pval001),l.pval101)) p55,
507: l.pval055 d55,
508: decode(l.pval056,cn,vn,vn,vn,
509: hr_pump_get.gl(l.pval056,'US_NEW_HIRE_EXCEPTIONS',d(l.pval001),l.pval101)) p56,
510: l.pval056 d56,
505: decode(l.pval055,cn,vn,vn,vn,
506: hr_pump_get.gl(l.pval055,'US_NEW_HIRE_STATUS',d(l.pval001),l.pval101)) p55,
507: l.pval055 d55,
508: decode(l.pval056,cn,vn,vn,vn,
509: hr_pump_get.gl(l.pval056,'US_NEW_HIRE_EXCEPTIONS',d(l.pval001),l.pval101)) p56,
510: l.pval056 d56,
511: decode(l.pval057,cn,vn,vn,'N',
512: hr_pump_get.gl(l.pval057,'YES_NO',d(l.pval001),l.pval101)) p57,
513: l.pval057 d57,
508: decode(l.pval056,cn,vn,vn,vn,
509: hr_pump_get.gl(l.pval056,'US_NEW_HIRE_EXCEPTIONS',d(l.pval001),l.pval101)) p56,
510: l.pval056 d56,
511: decode(l.pval057,cn,vn,vn,'N',
512: hr_pump_get.gl(l.pval057,'YES_NO',d(l.pval001),l.pval101)) p57,
513: l.pval057 d57,
514: decode(l.pval058,cn,vn,vn,vn,l.pval058) p58,
515: l.pval058 d58,
516: decode(l.pval059,cn,vn,vn,vn,
513: l.pval057 d57,
514: decode(l.pval058,cn,vn,vn,vn,l.pval058) p58,
515: l.pval058 d58,
516: decode(l.pval059,cn,vn,vn,vn,
517: hr_pump_get.gl(l.pval059,'YES_NO',d(l.pval001),l.pval101)) p59,
518: l.pval059 d59,
519: decode(l.pval060,cn,dn,vn,dn,d(l.pval060)) p60,
520: l.pval060 d60,
521: decode(l.pval061,cn,nn,vn,nn,n(l.pval061)) p61,
534: l.pval067 d67,
535: decode(l.pval068,cn,dn,vn,dn,d(l.pval068)) p68,
536: l.pval068 d68,
537: decode(l.pval069,cn,vn,vn,vn,
538: hr_pump_get.gl(l.pval069,'YES_NO',d(l.pval001),l.pval101)) p69,
539: l.pval069 d69,
540: decode(l.pval070,cn,dn,vn,dn,d(l.pval070)) p70,
541: l.pval070 d70,
542: decode(l.pval071,cn,vn,vn,vn,l.pval071) p71,
541: l.pval070 d70,
542: decode(l.pval071,cn,vn,vn,vn,l.pval071) p71,
543: l.pval071 d71,
544: decode(l.pval072,cn,vn,vn,vn,
545: hr_pump_get.gl(l.pval072,'WORK_SCHEDULE',d(l.pval001),l.pval101)) p72,
546: l.pval072 d72,
547: decode(l.pval073,cn,vn,vn,vn,l.pval073) p73,
548: l.pval073 d73,
549: decode(l.pval074,cn,dn,vn,dn,d(l.pval074)) p74,
623: c.p101 is null then
624: L_PERSON_TYPE_ID:=nn;
625: else
626: L_PERSON_TYPE_ID :=
627: hr_pump_get.get_person_type_id
628: (P_USER_PERSON_TYPE => c.p100
629: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
630: ,P_LANGUAGE_CODE => c.p101);
631: end if;
633: if c.p102 is null then
634: L_CORRESPONDENCE_LANGUAGE:=vn;
635: else
636: L_CORRESPONDENCE_LANGUAGE :=
637: hr_pump_get.GET_CORRESPONDENCE_LANGUAGE
638: (P_CORRESPONDENCE_LANGUAGE => c.p102);
639: end if;
640: --
641: if c.p103 is null then
641: if c.p103 is null then
642: L_BENEFIT_GROUP_ID:=nn;
643: else
644: L_BENEFIT_GROUP_ID :=
645: hr_pump_get.get_benefit_group_id
646: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
647: ,P_BENEFIT_GROUP => c.p103);
648: end if;
649: --