[Home] [Help]
375: l.pval004 d4,
376: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,
377: l.pval005 d5,
378: decode(l.pval006,cn,vn,vn,vn,
379: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval002),l.pval073)) p6,
380: l.pval006 d6,
381: decode(l.pval007,cn,vn,vn,vn,
382: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval002),l.pval073)) p7,
383: l.pval007 d7,
378: decode(l.pval006,cn,vn,vn,vn,
379: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval002),l.pval073)) p6,
380: l.pval006 d6,
381: decode(l.pval007,cn,vn,vn,vn,
382: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval002),l.pval073)) p7,
383: l.pval007 d7,
384: decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
385: l.pval008 d8,
386: decode(l.pval009,cn,vn,vn,vn,
383: l.pval007 d7,
384: decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
385: l.pval008 d8,
386: decode(l.pval009,cn,vn,vn,vn,
387: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval002),l.pval073)) p9,
388: l.pval009 d9,
389: decode(l.pval010,cn,nn,vn,nn,n(l.pval010)) p10,
390: l.pval010 d10,
391: decode(l.pval011,cn,nn,vn,nn,n(l.pval011)) p11,
390: l.pval010 d10,
391: decode(l.pval011,cn,nn,vn,nn,n(l.pval011)) p11,
392: l.pval011 d11,
393: decode(l.pval012,cn,vn,vn,vn,
394: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval002),l.pval073)) p12,
395: l.pval012 d12,
396: decode(l.pval013,cn,nn,vn,nn,n(l.pval013)) p13,
397: l.pval013 d13,
398: decode(l.pval014,cn,vn,vn,vn,
395: l.pval012 d12,
396: decode(l.pval013,cn,nn,vn,nn,n(l.pval013)) p13,
397: l.pval013 d13,
398: decode(l.pval014,cn,vn,vn,vn,
399: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval002),l.pval073)) p14,
400: l.pval014 d14,
401: decode(l.pval015,cn,nn,vn,nn,n(l.pval015)) p15,
402: l.pval015 d15,
403: decode(l.pval016,cn,vn,vn,vn,
400: l.pval014 d14,
401: decode(l.pval015,cn,nn,vn,nn,n(l.pval015)) p15,
402: l.pval015 d15,
403: decode(l.pval016,cn,vn,vn,vn,
404: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval002),l.pval073)) p16,
405: l.pval016 d16,
406: decode(l.pval017,cn,vn,vn,vn,
407: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval002),l.pval073)) p17,
408: l.pval017 d17,
403: decode(l.pval016,cn,vn,vn,vn,
404: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval002),l.pval073)) p16,
405: l.pval016 d16,
406: decode(l.pval017,cn,vn,vn,vn,
407: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval002),l.pval073)) p17,
408: l.pval017 d17,
409: decode(l.pval018,cn,vn,vn,vn,l.pval018) p18,
410: l.pval018 d18,
411: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,
410: l.pval018 d18,
411: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,
412: l.pval019 d19,
413: decode(l.pval020,cn,vn,vn,vn,
414: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval002),l.pval073)) p20,
415: l.pval020 d20,
416: decode(l.pval021,cn,vn,vn,vn,l.pval021) p21,
417: l.pval021 d21,
418: decode(l.pval022,cn,vn,vn,vn,
415: l.pval020 d20,
416: decode(l.pval021,cn,vn,vn,vn,l.pval021) p21,
417: l.pval021 d21,
418: decode(l.pval022,cn,vn,vn,vn,
419: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval002),l.pval073)) p22,
420: l.pval022 d22,
421: decode(l.pval023,cn,vn,vn,vn,l.pval023) p23,
422: l.pval023 d23,
423: decode(l.pval024,cn,vn,vn,vn,l.pval024) p24,
492: l.pval058 d58,
493: decode(l.pval059,cn,dn,vn,dn,d(l.pval059)) p59,
494: l.pval059 d59,
495: decode(l.pval060,cn,vn,vn,vn,
496: hr_pump_get.gl(l.pval060,'LEAV_REAS',d(l.pval002),l.pval073)) p60,
497: l.pval060 d60,
498: decode(l.pval061,cn,dn,vn,dn,d(l.pval061)) p61,
499: l.pval061 d61,
500: decode(l.pval062,cn,vn,vn,vn,l.pval062) p62,
596: if c.p71 is null then
597: L_PERSON_ID:=nn;
598: else
599: L_PERSON_ID :=
600: hr_pump_get.get_person_id
601: (P_PERSON_USER_KEY => c.p71);
602: end if;
603: --
604: if c.p72 is null or
606: c.p73 is null then
607: L_ORGANIZATION_ID:=nn;
608: else
609: L_ORGANIZATION_ID :=
610: hr_pump_get.GET_ORGANIZATION_ID
611: (P_ORGANIZATION_NAME => c.p72
612: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
613: ,P_EFFECTIVE_DATE => c.p2
614: ,P_LANGUAGE_CODE => c.p73);
618: c.p2 is null then
619: L_GRADE_ID:=nn;
620: else
621: L_GRADE_ID :=
622: hr_pump_get.GET_GRADE_ID
623: (P_GRADE_NAME => c.p74
624: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
625: ,P_EFFECTIVE_DATE => c.p2);
626: end if;
629: c.p2 is null then
630: L_POSITION_ID:=nn;
631: else
632: L_POSITION_ID :=
633: hr_pump_get.GET_POSITION_ID
634: (P_POSITION_NAME => c.p75
635: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
636: ,P_EFFECTIVE_DATE => c.p2);
637: end if;
640: c.p2 is null then
641: L_JOB_ID:=nn;
642: else
643: L_JOB_ID :=
644: hr_pump_get.GET_JOB_ID
645: (P_JOB_NAME => c.p76
646: ,P_EFFECTIVE_DATE => c.p2
647: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
648: end if;
651: c.p73 is null then
652: L_ASSIGNMENT_STATUS_TYPE_ID:=nn;
653: else
654: L_ASSIGNMENT_STATUS_TYPE_ID :=
655: hr_pump_get.GET_ASSIGNMENT_STATUS_TYPE_ID
656: (P_USER_STATUS => c.p77
657: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
658: ,P_LANGUAGE_CODE => c.p73);
659: end if;
662: c.p2 is null then
663: L_PAYROLL_ID:=nn;
664: else
665: L_PAYROLL_ID :=
666: hr_pump_get.GET_PAYROLL_ID
667: (P_PAYROLL_NAME => c.p78
668: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
669: ,P_EFFECTIVE_DATE => c.p2);
670: end if;
673: c.p73 is null then
674: L_LOCATION_ID:=nn;
675: else
676: L_LOCATION_ID :=
677: hr_pump_get.GET_LOCATION_ID
678: (P_LOCATION_CODE => c.p79
679: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
680: ,P_LANGUAGE_CODE => c.p73);
681: end if;
683: if c.p80 is null then
684: L_SUPERVISOR_ID:=nn;
685: else
686: L_SUPERVISOR_ID :=
687: hr_pump_get.GET_SUPERVISOR_ID
688: (P_SUPERVISOR_USER_KEY => c.p80);
689: end if;
690: --
691: if c.p81 is null then
691: if c.p81 is null then
692: L_SPECIAL_CEILING_STEP_ID:=nn;
693: else
694: L_SPECIAL_CEILING_STEP_ID :=
695: hr_pump_get.GET_SPECIAL_CEILING_STEP_ID
696: (P_SPECIAL_CEILIN_STEP_USER_KEY => c.p81);
697: end if;
698: --
699: if c.p82 is null or
700: c.p2 is null then
701: L_PEOPLE_GROUP_ID:=nn;
702: else
703: L_PEOPLE_GROUP_ID :=
704: hr_pump_get.GET_PEOPLE_GROUP_ID
705: (P_PEOPLE_GROUP_USER_NAME => c.p82
706: ,P_EFFECTIVE_DATE => c.p2);
707: end if;
708: --
710: c.p2 is null then
711: L_SOFT_CODING_KEYFLEX_ID:=nn;
712: else
713: L_SOFT_CODING_KEYFLEX_ID :=
714: hr_pump_get.GET_SOFT_CODING_KEYFLEX_ID
715: (P_CON_SEG_USER_NAME => c.p83
716: ,P_EFFECTIVE_DATE => c.p2);
717: end if;
718: --
719: if c.p84 is null then
720: L_PAY_BASIS_ID:=nn;
721: else
722: L_PAY_BASIS_ID :=
723: hr_pump_get.GET_PAY_BASIS_ID
724: (P_PAY_BASIS_NAME => c.p84
725: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
726: end if;
727: --
728: if c.p85 is null then
729: L_DEFAULT_CODE_COMB_ID:=nn;
730: else
731: L_DEFAULT_CODE_COMB_ID :=
732: hr_pump_get.GET_DEFAULT_CODE_COMB_ID
733: (P_DEFAULT_CODE_COMB_USER_KEY => c.p85);
734: end if;
735: --
736: if c.p86 is null then
736: if c.p86 is null then
737: L_SET_OF_BOOKS_ID:=nn;
738: else
739: L_SET_OF_BOOKS_ID :=
740: hr_pump_get.GET_SET_OF_BOOKS_ID
741: (P_SET_OF_BOOKS_NAME => c.p86);
742: end if;
743: --
744: if c.p87 is null or
745: c.p73 is null then
746: L_ORIGINAL_PERSON_TYPE:=vn;
747: else
748: L_ORIGINAL_PERSON_TYPE :=
749: hr_pump_get.GET_PERSON_TYPE_ID
750: (P_USER_PERSON_TYPE => c.p87
751: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
752: ,P_LANGUAGE_CODE => c.p73);
753: end if;
756: c.p73 is null then
757: L_ORIGINAL_PERSON_TYPE_ID:=vn;
758: else
759: L_ORIGINAL_PERSON_TYPE_ID :=
760: hr_pump_get.GET_ORIGINAL_PERSON_TYPE_ID
761: (P_USER_PERSON_TYPE => c.p87
762: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
763: ,P_LANGUAGE_CODE => c.p73);
764: end if;
767: c.p2 is null then
768: L_ABSENCE_TYPE:=vn;
769: else
770: L_ABSENCE_TYPE :=
771: hr_pump_get.GET_ABSENCE_ATTENDANCE_TYPE_ID
772: (P_AAT_USER_NAME => c.p88
773: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
774: ,P_EFFECTIVE_DATE => c.p2);
775: end if;