[Home] [Help]
422: decode(l.pval002,cn,vn,l.pval002) p2,
423: decode(l.pval003,cn,vn,vn,vh,l.pval003) p3,
424: l.pval003 d3,
425: decode(l.pval004,cn,vn,vn,vh,
426: hr_pump_get.gl(l.pval004,'EMP_ASSIGN_REASON',d(l.pval001),l.pval099)) p4,
427: l.pval004 d4,
428: decode(l.pval005,cn,vn,vn,vh,l.pval005) p5,
429: l.pval005 d5,
430: decode(l.pval006,cn,dn,vn,dh,d(l.pval006)) p6,
429: l.pval005 d5,
430: decode(l.pval006,cn,dn,vn,dh,d(l.pval006)) p6,
431: l.pval006 d6,
432: decode(l.pval007,cn,vn,vn,vh,
433: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval099)) p7,
434: l.pval007 d7,
435: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
436: l.pval008 d8,
437: decode(l.pval009,cn,vn,vn,vh,
434: l.pval007 d7,
435: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
436: l.pval008 d8,
437: decode(l.pval009,cn,vn,vn,vh,
438: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval099)) p9,
439: l.pval009 d9,
440: decode(l.pval010,cn,nn,vn,nh,n(l.pval010)) p10,
441: l.pval010 d10,
442: decode(l.pval011,cn,nn,vn,nh,n(l.pval011)) p11,
441: l.pval010 d10,
442: decode(l.pval011,cn,nn,vn,nh,n(l.pval011)) p11,
443: l.pval011 d11,
444: decode(l.pval012,cn,vn,vn,vh,
445: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval099)) p12,
446: l.pval012 d12,
447: decode(l.pval013,cn,nn,vn,nh,n(l.pval013)) p13,
448: l.pval013 d13,
449: decode(l.pval014,cn,vn,vn,vh,
446: l.pval012 d12,
447: decode(l.pval013,cn,nn,vn,nh,n(l.pval013)) p13,
448: l.pval013 d13,
449: decode(l.pval014,cn,vn,vn,vh,
450: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval099)) p14,
451: l.pval014 d14,
452: decode(l.pval015,cn,nn,vn,nh,n(l.pval015)) p15,
453: l.pval015 d15,
454: decode(l.pval016,cn,vn,vn,vh,
451: l.pval014 d14,
452: decode(l.pval015,cn,nn,vn,nh,n(l.pval015)) p15,
453: l.pval015 d15,
454: decode(l.pval016,cn,vn,vn,vh,
455: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval099)) p16,
456: l.pval016 d16,
457: decode(l.pval017,cn,vn,vn,vh,
458: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval099)) p17,
459: l.pval017 d17,
454: decode(l.pval016,cn,vn,vn,vh,
455: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval099)) p16,
456: l.pval016 d16,
457: decode(l.pval017,cn,vn,vn,vh,
458: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval099)) p17,
459: l.pval017 d17,
460: decode(l.pval018,cn,vn,vn,vh,l.pval018) p18,
461: l.pval018 d18,
462: decode(l.pval019,cn,vn,vn,vh,l.pval019) p19,
461: l.pval018 d18,
462: decode(l.pval019,cn,vn,vn,vh,l.pval019) p19,
463: l.pval019 d19,
464: decode(l.pval020,cn,vn,vn,vh,
465: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval099)) p20,
466: l.pval020 d20,
467: decode(l.pval021,cn,vn,vn,vh,
468: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval099)) p21,
469: l.pval021 d21,
464: decode(l.pval020,cn,vn,vn,vh,
465: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval099)) p20,
466: l.pval020 d20,
467: decode(l.pval021,cn,vn,vn,vh,
468: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval099)) p21,
469: l.pval021 d21,
470: decode(l.pval022,cn,vn,vn,vh,
471: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval099)) p22,
472: l.pval022 d22,
467: decode(l.pval021,cn,vn,vn,vh,
468: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval099)) p21,
469: l.pval021 d21,
470: decode(l.pval022,cn,vn,vn,vh,
471: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval099)) p22,
472: l.pval022 d22,
473: decode(l.pval023,cn,vn,vn,vh,l.pval023) p23,
474: l.pval023 d23,
475: decode(l.pval024,cn,vn,vn,vh,l.pval024) p24,
534: l.pval053 d53,
535: decode(l.pval054,cn,vn,vn,vh,l.pval054) p54,
536: l.pval054 d54,
537: decode(l.pval055,cn,vn,vn,vh,
538: hr_pump_get.gl(l.pval055,'YES_NO',d(l.pval001),l.pval099)) p55,
539: l.pval055 d55,
540: decode(l.pval056,cn,vn,vn,vh,
541: hr_pump_get.gl(l.pval056,'HR_MX_EMP_CAT',d(l.pval001),l.pval099)) p56,
542: l.pval056 d56,
537: decode(l.pval055,cn,vn,vn,vh,
538: hr_pump_get.gl(l.pval055,'YES_NO',d(l.pval001),l.pval099)) p55,
539: l.pval055 d55,
540: decode(l.pval056,cn,vn,vn,vh,
541: hr_pump_get.gl(l.pval056,'HR_MX_EMP_CAT',d(l.pval001),l.pval099)) p56,
542: l.pval056 d56,
543: decode(l.pval057,cn,vn,vn,vh,
544: hr_pump_get.gl(l.pval057,'HR_MX_SS_SALARY_TYPE',d(l.pval001),l.pval099)) p57,
545: l.pval057 d57,
540: decode(l.pval056,cn,vn,vn,vh,
541: hr_pump_get.gl(l.pval056,'HR_MX_EMP_CAT',d(l.pval001),l.pval099)) p56,
542: l.pval056 d56,
543: decode(l.pval057,cn,vn,vn,vh,
544: hr_pump_get.gl(l.pval057,'HR_MX_SS_SALARY_TYPE',d(l.pval001),l.pval099)) p57,
545: l.pval057 d57,
546: decode(l.pval058,cn,vn,vn,vh,l.pval058) p58,
547: l.pval058 d58,
548: decode(l.pval059,cn,vn,vn,vh,l.pval059) p59,
597: l.pval083 d83,
598: decode(l.pval084,cn,vn,vn,vh,l.pval084) p84,
599: l.pval084 d84,
600: decode(l.pval085,cn,vn,vn,vh,
601: hr_pump_get.gl(l.pval085,'MX_STAT_IMSS_LEAVING_REASON',d(l.pval001),l.pval099)) p85,
602: l.pval085 d85,
603: decode(l.pval086,cn,nn,n(l.pval086)) p86,
604: l.pval087 p87,
605: l.pval088 p88,
677: if c.p96 is null then
678: L_ASSIGNMENT_ID:=nn;
679: else
680: L_ASSIGNMENT_ID :=
681: hr_pump_get.get_assignment_id
682: (P_ASSIGNMENT_USER_KEY => c.p96);
683: end if;
684: --
685: if c.p96 is null or
686: c.p1 is null then
687: L_OBJECT_VERSION_NUMBER:=nn;
688: else
689: L_OBJECT_VERSION_NUMBER :=
690: hr_pump_get.GET_ASG_OVN
691: (P_ASSIGNMENT_USER_KEY => c.p96
692: ,P_EFFECTIVE_DATE => c.p1);
693: end if;
694: --
697: elsif c.d97 is null then
698: L_SUPERVISOR_ID:=nh;
699: else
700: L_SUPERVISOR_ID :=
701: hr_pump_get.get_supervisor_id
702: (P_SUPERVISOR_USER_KEY => c.p97);
703: end if;
704: --
705: if c.d98=cn or
709: c.d99 is null then
710: L_ASSIGNMENT_STATUS_TYPE_ID:=nh;
711: else
712: L_ASSIGNMENT_STATUS_TYPE_ID :=
713: hr_pump_get.get_assignment_status_type_id
714: (P_USER_STATUS => c.p98
715: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
716: ,P_LANGUAGE_CODE => c.p99);
717: end if;
721: elsif c.d100 is null then
722: L_DEFAULT_CODE_COMB_ID:=nh;
723: else
724: L_DEFAULT_CODE_COMB_ID :=
725: hr_pump_get.get_default_code_comb_id
726: (P_DEFAULT_CODE_COMB_USER_KEY => c.p100);
727: end if;
728: --
729: if c.d101=cn then
731: elsif c.d101 is null then
732: L_SET_OF_BOOKS_ID:=nh;
733: else
734: L_SET_OF_BOOKS_ID :=
735: hr_pump_get.get_set_of_books_id
736: (P_SET_OF_BOOKS_NAME => c.p101);
737: end if;
738: --
739: if c.d102=cn then
752: elsif c.d103 is null then
753: L_TIMECARD_APPROVER:=vh;
754: else
755: L_TIMECARD_APPROVER :=
756: hr_pump_get.GET_TIMECARD_APPROVER_ID
757: (P_TIMECARD_APPROVER_USER_KEY => c.p103);
758: end if;
759: --
760: if c.d104=cn then
772: elsif c.d105 is null then
773: L_CONTRACT_ID:=nh;
774: else
775: L_CONTRACT_ID :=
776: hr_pump_get.get_contract_id
777: (P_CONTRACT_USER_KEY => c.p105);
778: end if;
779: --
780: if c.d106=cn or
785: c.d99 is null then
786: L_ESTABLISHMENT_ID:=nh;
787: else
788: L_ESTABLISHMENT_ID :=
789: hr_pump_get.GET_ESTABLISHMENT_ORG_ID
790: (P_ESTABLISHMENT_ORG_NAME => c.p106
791: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
792: ,P_EFFECTIVE_DATE => c.p1
793: ,P_LANGUAGE_CODE => c.p99);
799: elsif c.d107 is null then
800: L_COLLECTIVE_AGREEMENT_ID:=nh;
801: else
802: L_COLLECTIVE_AGREEMENT_ID :=
803: hr_pump_get.get_collective_agreement_id
804: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
805: ,P_CAGR_NAME => c.p107
806: ,P_EFFECTIVE_DATE => c.p1);
807: end if;
811: elsif c.d108 is null then
812: L_CAGR_ID_FLEX_NUM:=nh;
813: else
814: L_CAGR_ID_FLEX_NUM :=
815: hr_pump_get.GET_CAGR_ID_FLEX_NUM
816: (P_CAGR_ID_FLEX_NUM_USER_KEY => c.p108);
817: end if;
818: --
819: if c.d109=cn then
821: elsif c.d109 is null then
822: L_SUPERVISOR_ASSIGNMENT_ID:=nh;
823: else
824: L_SUPERVISOR_ASSIGNMENT_ID :=
825: hr_pump_get.get_supervisor_assignment_id
826: (P_SVR_ASSIGNMENT_USER_KEY => c.p109);
827: end if;
828: --
829: if c.p110 is null or
830: c.p1 is null then
831: L_SOFT_CODING_KEYFLEX_ID:=nn;
832: else
833: L_SOFT_CODING_KEYFLEX_ID :=
834: hr_pump_get.get_soft_coding_keyflex_id
835: (P_CON_SEG_USER_NAME => c.p110
836: ,P_EFFECTIVE_DATE => c.p1);
837: end if;
838: --