[Home] [Help]
444: select l.rowid myrowid,
445: decode(l.pval001,cn,dn,d(l.pval001)) p1,
446: decode(l.pval002,cn,vn,l.pval002) p2,
447: decode(l.pval003,cn,vn,vn,vn,
448: hr_pump_get.gl(l.pval003,'EMP_ASSIGN_REASON',d(l.pval001),l.pval108)) p3,
449: l.pval003 d3,
450: decode(l.pval004,cn,vn,vn,vn,l.pval004) p4,
451: l.pval004 d4,
452: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,
451: l.pval004 d4,
452: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,
453: l.pval005 d5,
454: decode(l.pval006,cn,vn,vn,vn,
455: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval001),l.pval108)) p6,
456: l.pval006 d6,
457: decode(l.pval007,cn,vn,vn,vn,
458: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval108)) p7,
459: l.pval007 d7,
454: decode(l.pval006,cn,vn,vn,vn,
455: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval001),l.pval108)) p6,
456: l.pval006 d6,
457: decode(l.pval007,cn,vn,vn,vn,
458: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval108)) p7,
459: l.pval007 d7,
460: decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
461: l.pval008 d8,
462: decode(l.pval009,cn,vn,vn,vn,
459: l.pval007 d7,
460: decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
461: l.pval008 d8,
462: decode(l.pval009,cn,vn,vn,vn,
463: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval108)) p9,
464: l.pval009 d9,
465: decode(l.pval010,cn,nn,vn,nn,n(l.pval010)) p10,
466: l.pval010 d10,
467: decode(l.pval011,cn,nn,vn,nn,n(l.pval011)) p11,
466: l.pval010 d10,
467: decode(l.pval011,cn,nn,vn,nn,n(l.pval011)) p11,
468: l.pval011 d11,
469: decode(l.pval012,cn,vn,vn,vn,
470: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval108)) p12,
471: l.pval012 d12,
472: decode(l.pval013,cn,nn,vn,nn,n(l.pval013)) p13,
473: l.pval013 d13,
474: decode(l.pval014,cn,vn,vn,vn,
471: l.pval012 d12,
472: decode(l.pval013,cn,nn,vn,nn,n(l.pval013)) p13,
473: l.pval013 d13,
474: decode(l.pval014,cn,vn,vn,vn,
475: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval108)) p14,
476: l.pval014 d14,
477: decode(l.pval015,cn,nn,vn,nn,n(l.pval015)) p15,
478: l.pval015 d15,
479: decode(l.pval016,cn,vn,vn,vn,
476: l.pval014 d14,
477: decode(l.pval015,cn,nn,vn,nn,n(l.pval015)) p15,
478: l.pval015 d15,
479: decode(l.pval016,cn,vn,vn,vn,
480: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval108)) p16,
481: l.pval016 d16,
482: decode(l.pval017,cn,vn,vn,vn,
483: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval108)) p17,
484: l.pval017 d17,
479: decode(l.pval016,cn,vn,vn,vn,
480: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval108)) p16,
481: l.pval016 d16,
482: decode(l.pval017,cn,vn,vn,vn,
483: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval108)) p17,
484: l.pval017 d17,
485: decode(l.pval018,cn,vn,vn,vn,l.pval018) p18,
486: l.pval018 d18,
487: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,
486: l.pval018 d18,
487: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,
488: l.pval019 d19,
489: decode(l.pval020,cn,vn,vn,vn,
490: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval108)) p20,
491: l.pval020 d20,
492: decode(l.pval021,cn,vn,vn,'N',
493: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval108)) p21,
494: l.pval021 d21,
489: decode(l.pval020,cn,vn,vn,vn,
490: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval108)) p20,
491: l.pval020 d20,
492: decode(l.pval021,cn,vn,vn,'N',
493: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval108)) p21,
494: l.pval021 d21,
495: decode(l.pval022,cn,vn,vn,vn,
496: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval108)) p22,
497: l.pval022 d22,
492: decode(l.pval021,cn,vn,vn,'N',
493: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval108)) p21,
494: l.pval021 d21,
495: decode(l.pval022,cn,vn,vn,vn,
496: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval108)) p22,
497: l.pval022 d22,
498: decode(l.pval023,cn,vn,vn,vn,l.pval023) p23,
499: l.pval023 d23,
500: decode(l.pval024,cn,vn,vn,vn,l.pval024) p24,
559: l.pval053 d53,
560: decode(l.pval054,cn,vn,vn,vn,l.pval054) p54,
561: l.pval054 d54,
562: decode(l.pval055,cn,vn,vn,vn,
563: hr_pump_get.gl(l.pval055,'YES_NO',d(l.pval001),l.pval108)) p55,
564: l.pval055 d55,
565: decode(l.pval056,cn,vn,vn,vn,
566: hr_pump_get.gl(l.pval056,'US_SHIFTS',d(l.pval001),l.pval108)) p56,
567: l.pval056 d56,
562: decode(l.pval055,cn,vn,vn,vn,
563: hr_pump_get.gl(l.pval055,'YES_NO',d(l.pval001),l.pval108)) p55,
564: l.pval055 d55,
565: decode(l.pval056,cn,vn,vn,vn,
566: hr_pump_get.gl(l.pval056,'US_SHIFTS',d(l.pval001),l.pval108)) p56,
567: l.pval056 d56,
568: decode(l.pval057,cn,vn,vn,vn,l.pval057) p57,
569: l.pval057 d57,
570: decode(l.pval058,cn,vn,vn,vn,
567: l.pval056 d56,
568: decode(l.pval057,cn,vn,vn,vn,l.pval057) p57,
569: l.pval057 d57,
570: decode(l.pval058,cn,vn,vn,vn,
571: hr_pump_get.gl(l.pval058,'YES_NO',d(l.pval001),l.pval108)) p58,
572: l.pval058 d58,
573: decode(l.pval059,cn,vn,vn,vn,l.pval059) p59,
574: l.pval059 d59,
575: decode(l.pval060,cn,vn,vn,vn,l.pval060) p60,
727: if c.p106 is null then
728: L_PERSON_ID:=nn;
729: else
730: L_PERSON_ID :=
731: hr_pump_get.get_person_id
732: (P_PERSON_USER_KEY => c.p106);
733: end if;
734: --
735: if c.p107 is null or
737: c.p108 is null then
738: L_ORGANIZATION_ID:=nn;
739: else
740: L_ORGANIZATION_ID :=
741: hr_pump_get.get_organization_id
742: (P_ORGANIZATION_NAME => c.p107
743: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
744: ,P_EFFECTIVE_DATE => c.p1
745: ,P_LANGUAGE_CODE => c.p108);
749: c.p1 is null then
750: L_GRADE_ID:=nn;
751: else
752: L_GRADE_ID :=
753: hr_pump_get.get_grade_id
754: (P_GRADE_NAME => c.p109
755: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
756: ,P_EFFECTIVE_DATE => c.p1);
757: end if;
760: c.p1 is null then
761: L_POSITION_ID:=nn;
762: else
763: L_POSITION_ID :=
764: hr_pump_get.get_position_id
765: (P_POSITION_NAME => c.p110
766: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
767: ,P_EFFECTIVE_DATE => c.p1);
768: end if;
771: c.p1 is null then
772: L_JOB_ID:=nn;
773: else
774: L_JOB_ID :=
775: hr_pump_get.get_job_id
776: (P_JOB_NAME => c.p111
777: ,P_EFFECTIVE_DATE => c.p1
778: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
779: end if;
782: c.p108 is null then
783: L_ASSIGNMENT_STATUS_TYPE_ID:=nn;
784: else
785: L_ASSIGNMENT_STATUS_TYPE_ID :=
786: hr_pump_get.get_assignment_status_type_id
787: (P_USER_STATUS => c.p112
788: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
789: ,P_LANGUAGE_CODE => c.p108);
790: end if;
793: c.p1 is null then
794: L_PAYROLL_ID:=nn;
795: else
796: L_PAYROLL_ID :=
797: hr_pump_get.get_payroll_id
798: (P_PAYROLL_NAME => c.p113
799: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
800: ,P_EFFECTIVE_DATE => c.p1);
801: end if;
804: c.p108 is null then
805: L_LOCATION_ID:=nn;
806: else
807: L_LOCATION_ID :=
808: hr_pump_get.get_location_id
809: (P_LOCATION_CODE => c.p114
810: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
811: ,P_LANGUAGE_CODE => c.p108);
812: end if;
814: if c.p115 is null then
815: L_SUPERVISOR_ID:=nn;
816: else
817: L_SUPERVISOR_ID :=
818: hr_pump_get.get_supervisor_id
819: (P_SUPERVISOR_USER_KEY => c.p115);
820: end if;
821: --
822: if c.p116 is null then
822: if c.p116 is null then
823: L_SPECIAL_CEILING_STEP_ID:=nn;
824: else
825: L_SPECIAL_CEILING_STEP_ID :=
826: hr_pump_get.get_special_ceiling_step_id
827: (P_SPECIAL_CEILIN_STEP_USER_KEY => c.p116);
828: end if;
829: --
830: if c.p117 is null then
830: if c.p117 is null then
831: L_PAY_BASIS_ID:=nn;
832: else
833: L_PAY_BASIS_ID :=
834: hr_pump_get.get_pay_basis_id
835: (P_PAY_BASIS_NAME => c.p117
836: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
837: end if;
838: --
839: if c.p118 is null then
840: L_DEFAULT_CODE_COMB_ID:=nn;
841: else
842: L_DEFAULT_CODE_COMB_ID :=
843: hr_pump_get.get_default_code_comb_id
844: (P_DEFAULT_CODE_COMB_USER_KEY => c.p118);
845: end if;
846: --
847: if c.p119 is null then
847: if c.p119 is null then
848: L_SET_OF_BOOKS_ID:=nn;
849: else
850: L_SET_OF_BOOKS_ID :=
851: hr_pump_get.get_set_of_books_id
852: (P_SET_OF_BOOKS_NAME => c.p119);
853: end if;
854: --
855: if c.p120 is null or
856: c.p1 is null then
857: L_TAX_UNIT:=vn;
858: else
859: L_TAX_UNIT :=
860: hr_pump_get.GET_TAX_UNIT_ID
861: (P_TAX_UNIT_NAME => c.p120
862: ,P_EFFECTIVE_DATE => c.p1);
863: end if;
864: --
865: if c.p121 is null then
866: L_TIMECARD_APPROVER:=vn;
867: else
868: L_TIMECARD_APPROVER :=
869: hr_pump_get.GET_TIMECARD_APPROVER_ID
870: (P_TIMECARD_APPROVER_USER_KEY => c.p121);
871: end if;
872: --
873: if c.p122 is null or
876: c.p108 is null then
877: L_WORK_SCHEDULE:=vn;
878: else
879: L_WORK_SCHEDULE :=
880: hr_pump_get.GET_WORK_SCHEDULE
881: (P_WORK_SCHEDULE => c.p122
882: ,P_ORGANIZATION_NAME => c.p107
883: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
884: ,P_EFFECTIVE_DATE => c.p1
889: c.p1 is null then
890: L_EEO_1_ESTABLISHMENT:=vn;
891: else
892: L_EEO_1_ESTABLISHMENT :=
893: hr_pump_get.GET_EEO_1_ESTABLISHMENT_ID
894: (P_EEO_1_ESTABLISHMENT => c.p123
895: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
896: ,P_EFFECTIVE_DATE => c.p1);
897: end if;
899: if c.p124 is null then
900: L_SUPERVISOR_ASSIGNMENT_ID:=nn;
901: else
902: L_SUPERVISOR_ASSIGNMENT_ID :=
903: hr_pump_get.get_supervisor_assignment_id
904: (P_SVR_ASSIGNMENT_USER_KEY => c.p124);
905: end if;
906: --
907: hr_data_pump.api_trc_on;