[Home] [Help]
414: select l.rowid myrowid,
415: decode(l.pval001,cn,dn,d(l.pval001)) p1,
416: decode(l.pval002,cn,vn,l.pval002) p2,
417: decode(l.pval003,cn,vn,vn,vn,
418: hr_pump_get.gl(l.pval003,'EMP_ASSIGN_REASON',d(l.pval001),l.pval100)) p3,
419: l.pval003 d3,
420: decode(l.pval004,cn,vn,vn,vn,l.pval004) p4,
421: l.pval004 d4,
422: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,
421: l.pval004 d4,
422: decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,
423: l.pval005 d5,
424: decode(l.pval006,cn,vn,vn,vn,
425: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval001),l.pval100)) p6,
426: l.pval006 d6,
427: decode(l.pval007,cn,vn,vn,vn,
428: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval100)) p7,
429: l.pval007 d7,
424: decode(l.pval006,cn,vn,vn,vn,
425: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval001),l.pval100)) p6,
426: l.pval006 d6,
427: decode(l.pval007,cn,vn,vn,vn,
428: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval100)) p7,
429: l.pval007 d7,
430: decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
431: l.pval008 d8,
432: decode(l.pval009,cn,vn,vn,vn,
429: l.pval007 d7,
430: decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
431: l.pval008 d8,
432: decode(l.pval009,cn,vn,vn,vn,
433: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval100)) p9,
434: l.pval009 d9,
435: decode(l.pval010,cn,nn,vn,nn,n(l.pval010)) p10,
436: l.pval010 d10,
437: decode(l.pval011,cn,nn,vn,nn,n(l.pval011)) p11,
436: l.pval010 d10,
437: decode(l.pval011,cn,nn,vn,nn,n(l.pval011)) p11,
438: l.pval011 d11,
439: decode(l.pval012,cn,vn,vn,vn,
440: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval100)) p12,
441: l.pval012 d12,
442: decode(l.pval013,cn,nn,vn,nn,n(l.pval013)) p13,
443: l.pval013 d13,
444: decode(l.pval014,cn,vn,vn,vn,
441: l.pval012 d12,
442: decode(l.pval013,cn,nn,vn,nn,n(l.pval013)) p13,
443: l.pval013 d13,
444: decode(l.pval014,cn,vn,vn,vn,
445: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval100)) p14,
446: l.pval014 d14,
447: decode(l.pval015,cn,nn,vn,nn,n(l.pval015)) p15,
448: l.pval015 d15,
449: decode(l.pval016,cn,vn,vn,vn,
446: l.pval014 d14,
447: decode(l.pval015,cn,nn,vn,nn,n(l.pval015)) p15,
448: l.pval015 d15,
449: decode(l.pval016,cn,vn,vn,vn,
450: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval100)) p16,
451: l.pval016 d16,
452: decode(l.pval017,cn,vn,vn,vn,
453: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval100)) p17,
454: l.pval017 d17,
449: decode(l.pval016,cn,vn,vn,vn,
450: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval100)) p16,
451: l.pval016 d16,
452: decode(l.pval017,cn,vn,vn,vn,
453: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval100)) p17,
454: l.pval017 d17,
455: decode(l.pval018,cn,vn,vn,vn,l.pval018) p18,
456: l.pval018 d18,
457: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,
456: l.pval018 d18,
457: decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,
458: l.pval019 d19,
459: decode(l.pval020,cn,vn,vn,vn,
460: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval100)) p20,
461: l.pval020 d20,
462: decode(l.pval021,cn,vn,vn,'N',
463: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval100)) p21,
464: l.pval021 d21,
459: decode(l.pval020,cn,vn,vn,vn,
460: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval100)) p20,
461: l.pval020 d20,
462: decode(l.pval021,cn,vn,vn,'N',
463: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval100)) p21,
464: l.pval021 d21,
465: decode(l.pval022,cn,vn,vn,vn,
466: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval100)) p22,
467: l.pval022 d22,
462: decode(l.pval021,cn,vn,vn,'N',
463: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval100)) p21,
464: l.pval021 d21,
465: decode(l.pval022,cn,vn,vn,vn,
466: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval100)) p22,
467: l.pval022 d22,
468: decode(l.pval023,cn,vn,vn,vn,l.pval023) p23,
469: l.pval023 d23,
470: decode(l.pval024,cn,vn,vn,vn,l.pval024) p24,
668: if c.p98 is null then
669: L_PERSON_ID:=nn;
670: else
671: L_PERSON_ID :=
672: hr_pump_get.get_person_id
673: (P_PERSON_USER_KEY => c.p98);
674: end if;
675: --
676: if c.p99 is null or
678: c.p100 is null then
679: L_ORGANIZATION_ID:=nn;
680: else
681: L_ORGANIZATION_ID :=
682: hr_pump_get.get_organization_id
683: (P_ORGANIZATION_NAME => c.p99
684: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
685: ,P_EFFECTIVE_DATE => c.p1
686: ,P_LANGUAGE_CODE => c.p100);
690: c.p1 is null then
691: L_GRADE_ID:=nn;
692: else
693: L_GRADE_ID :=
694: hr_pump_get.get_grade_id
695: (P_GRADE_NAME => c.p101
696: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
697: ,P_EFFECTIVE_DATE => c.p1);
698: end if;
701: c.p1 is null then
702: L_POSITION_ID:=nn;
703: else
704: L_POSITION_ID :=
705: hr_pump_get.get_position_id
706: (P_POSITION_NAME => c.p102
707: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
708: ,P_EFFECTIVE_DATE => c.p1);
709: end if;
712: c.p1 is null then
713: L_JOB_ID:=nn;
714: else
715: L_JOB_ID :=
716: hr_pump_get.get_job_id
717: (P_JOB_NAME => c.p103
718: ,P_EFFECTIVE_DATE => c.p1
719: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
720: end if;
723: c.p100 is null then
724: L_ASSIGNMENT_STATUS_TYPE_ID:=nn;
725: else
726: L_ASSIGNMENT_STATUS_TYPE_ID :=
727: hr_pump_get.get_assignment_status_type_id
728: (P_USER_STATUS => c.p104
729: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
730: ,P_LANGUAGE_CODE => c.p100);
731: end if;
734: c.p1 is null then
735: L_PAYROLL_ID:=nn;
736: else
737: L_PAYROLL_ID :=
738: hr_pump_get.get_payroll_id
739: (P_PAYROLL_NAME => c.p105
740: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
741: ,P_EFFECTIVE_DATE => c.p1);
742: end if;
745: c.p100 is null then
746: L_LOCATION_ID:=nn;
747: else
748: L_LOCATION_ID :=
749: hr_pump_get.get_location_id
750: (P_LOCATION_CODE => c.p106
751: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
752: ,P_LANGUAGE_CODE => c.p100);
753: end if;
755: if c.p107 is null then
756: L_SUPERVISOR_ID:=nn;
757: else
758: L_SUPERVISOR_ID :=
759: hr_pump_get.get_supervisor_id
760: (P_SUPERVISOR_USER_KEY => c.p107);
761: end if;
762: --
763: if c.p108 is null then
763: if c.p108 is null then
764: L_SPECIAL_CEILING_STEP_ID:=nn;
765: else
766: L_SPECIAL_CEILING_STEP_ID :=
767: hr_pump_get.get_special_ceiling_step_id
768: (P_SPECIAL_CEILIN_STEP_USER_KEY => c.p108);
769: end if;
770: --
771: if c.p109 is null then
771: if c.p109 is null then
772: L_PAY_BASIS_ID:=nn;
773: else
774: L_PAY_BASIS_ID :=
775: hr_pump_get.get_pay_basis_id
776: (P_PAY_BASIS_NAME => c.p109
777: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
778: end if;
779: --
780: if c.p110 is null then
781: L_DEFAULT_CODE_COMB_ID:=nn;
782: else
783: L_DEFAULT_CODE_COMB_ID :=
784: hr_pump_get.get_default_code_comb_id
785: (P_DEFAULT_CODE_COMB_USER_KEY => c.p110);
786: end if;
787: --
788: if c.p111 is null then
788: if c.p111 is null then
789: L_SET_OF_BOOKS_ID:=nn;
790: else
791: L_SET_OF_BOOKS_ID :=
792: hr_pump_get.get_set_of_books_id
793: (P_SET_OF_BOOKS_NAME => c.p111);
794: end if;
795: --
796: if c.p112 is null then
796: if c.p112 is null then
797: L_SUPERVISOR_ASSIGNMENT_ID:=nn;
798: else
799: L_SUPERVISOR_ASSIGNMENT_ID :=
800: hr_pump_get.get_supervisor_assignment_id
801: (P_SVR_ASSIGNMENT_USER_KEY => c.p112);
802: end if;
803: --
804: hr_data_pump.api_trc_on;