[Home] [Help]
471: l.pval006 d6,
472: decode(l.pval007,cn,vn,vn,vn,l.pval007) p7,
473: l.pval007 d7,
474: decode(l.pval008,cn,vn,vn,vn,
475: hr_pump_get.gl(l.pval008,'HOME_OFFICE',d(l.pval001),l.pval124)) p8,
476: l.pval008 d8,
477: decode(l.pval009,cn,vn,vn,vn,l.pval009) p9,
478: l.pval009 d9,
479: decode(l.pval010,cn,vn,vn,vn,l.pval010) p10,
478: l.pval009 d9,
479: decode(l.pval010,cn,vn,vn,vn,l.pval010) p10,
480: l.pval010 d10,
481: decode(l.pval011,cn,vn,vn,vn,
482: hr_pump_get.gl(l.pval011,'MAR_STATUS',d(l.pval001),l.pval124)) p11,
483: l.pval011 d11,
484: decode(l.pval012,cn,vn,vn,vn,l.pval012) p12,
485: l.pval012 d12,
486: decode(l.pval013,cn,vn,vn,vn,
483: l.pval011 d11,
484: decode(l.pval012,cn,vn,vn,vn,l.pval012) p12,
485: l.pval012 d12,
486: decode(l.pval013,cn,vn,vn,vn,
487: hr_pump_get.gl(l.pval013,'NATIONALITY',d(l.pval001),l.pval124)) p13,
488: l.pval013 d13,
489: decode(l.pval014,cn,vn,vn,vn,l.pval014) p14,
490: l.pval014 d14,
491: decode(l.pval015,cn,vn,vn,vn,l.pval015) p15,
490: l.pval014 d14,
491: decode(l.pval015,cn,vn,vn,vn,l.pval015) p15,
492: l.pval015 d15,
493: decode(l.pval016,cn,vn,vn,vn,
494: hr_pump_get.gl(l.pval016,'REGISTERED_DISABLED',d(l.pval001),l.pval124)) p16,
495: l.pval016 d16,
496: decode(l.pval017,cn,vn,vn,vn,
497: hr_pump_get.gl(l.pval017,'SEX',d(l.pval001),l.pval124)) p17,
498: l.pval017 d17,
493: decode(l.pval016,cn,vn,vn,vn,
494: hr_pump_get.gl(l.pval016,'REGISTERED_DISABLED',d(l.pval001),l.pval124)) p16,
495: l.pval016 d16,
496: decode(l.pval017,cn,vn,vn,vn,
497: hr_pump_get.gl(l.pval017,'SEX',d(l.pval001),l.pval124)) p17,
498: l.pval017 d17,
499: decode(l.pval018,cn,vn,vn,vn,
500: hr_pump_get.gl(l.pval018,'TITLE',d(l.pval001),l.pval124)) p18,
501: l.pval018 d18,
496: decode(l.pval017,cn,vn,vn,vn,
497: hr_pump_get.gl(l.pval017,'SEX',d(l.pval001),l.pval124)) p17,
498: l.pval017 d17,
499: decode(l.pval018,cn,vn,vn,vn,
500: hr_pump_get.gl(l.pval018,'TITLE',d(l.pval001),l.pval124)) p18,
501: l.pval018 d18,
502: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,
503: l.pval019 d19,
504: decode(l.pval020,cn,vn,vn,vn,l.pval020) p20,
625: l.pval080 d80,
626: decode(l.pval081,cn,vn,vn,vn,l.pval081) p81,
627: l.pval081 d81,
628: decode(l.pval082,cn,vn,vn,vn,
629: hr_pump_get.gl(l.pval082,'YES_NO',d(l.pval001),l.pval124)) p82,
630: l.pval082 d82,
631: decode(l.pval083,cn,dn,vn,dn,d(l.pval083)) p83,
632: l.pval083 d83,
633: decode(l.pval084,cn,nn,vn,nn,n(l.pval084)) p84,
646: l.pval090 d90,
647: decode(l.pval091,cn,dn,vn,dn,d(l.pval091)) p91,
648: l.pval091 d91,
649: decode(l.pval092,cn,vn,vn,vn,
650: hr_pump_get.gl(l.pval092,'YES_NO',d(l.pval001),l.pval124)) p92,
651: l.pval092 d92,
652: decode(l.pval093,cn,dn,vn,dn,d(l.pval093)) p93,
653: l.pval093 d93,
654: decode(l.pval094,cn,vn,vn,vn,l.pval094) p94,
653: l.pval093 d93,
654: decode(l.pval094,cn,vn,vn,vn,l.pval094) p94,
655: l.pval094 d94,
656: decode(l.pval095,cn,vn,vn,vn,
657: hr_pump_get.gl(l.pval095,'WORK_SCHEDULE',d(l.pval001),l.pval124)) p95,
658: l.pval095 d95,
659: decode(l.pval096,cn,vn,vn,vn,l.pval096) p96,
660: l.pval096 d96,
661: decode(l.pval097,cn,dn,vn,dn,d(l.pval097)) p97,
738: c.p124 is null then
739: L_PERSON_TYPE_ID:=nn;
740: else
741: L_PERSON_TYPE_ID :=
742: hr_pump_get.get_person_type_id
743: (P_USER_PERSON_TYPE => c.p123
744: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
745: ,P_LANGUAGE_CODE => c.p124);
746: end if;
748: if c.p125 is null then
749: L_CORRESPONDENCE_LANGUAGE:=vn;
750: else
751: L_CORRESPONDENCE_LANGUAGE :=
752: hr_pump_get.GET_CORRESPONDENCE_LANGUAGE
753: (P_CORRESPONDENCE_LANGUAGE => c.p125);
754: end if;
755: --
756: if c.p126 is null then
756: if c.p126 is null then
757: L_BENEFIT_GROUP_ID:=nn;
758: else
759: L_BENEFIT_GROUP_ID :=
760: hr_pump_get.get_benefit_group_id
761: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
762: ,P_BENEFIT_GROUP => c.p126);
763: end if;
764: --
765: if c.p127 is null then
766: L_VACANCY_ID:=nn;
767: else
768: L_VACANCY_ID :=
769: hr_pump_get.get_vacancy_id
770: (P_VACANCY_USER_KEY => c.p127);
771: end if;
772: --
773: hr_data_pump.api_trc_on;