eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRDPP_CREATE_BEN_ASG dependencies on HR_PUMP_GET

Line 379: hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval002),l.pval073)) p6,

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,

Line 382: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval002),l.pval073)) p7,

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,

Line 387: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval002),l.pval073)) p9,

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,

Line 394: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval002),l.pval073)) p12,

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,

Line 399: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval002),l.pval073)) p14,

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,

Line 404: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval002),l.pval073)) p16,

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,

Line 407: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval002),l.pval073)) p17,

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,

Line 414: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval002),l.pval073)) p20,

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,

Line 419: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval002),l.pval073)) p22,

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,

Line 496: hr_pump_get.gl(l.pval060,'LEAV_REAS',d(l.pval002),l.pval073)) p60,

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,

Line 599: hr_pump_get.get_person_id

595: if c.p71 is null then
596: L_PERSON_ID:=nn;
597: else
598: L_PERSON_ID :=
599: hr_pump_get.get_person_id
600: (P_PERSON_USER_KEY => c.p71);
601: end if;
602: --
603: if c.p72 is null or

Line 609: hr_pump_get.GET_ORGANIZATION_ID

605: c.p73 is null then
606: L_ORGANIZATION_ID:=nn;
607: else
608: L_ORGANIZATION_ID :=
609: hr_pump_get.GET_ORGANIZATION_ID
610: (P_ORGANIZATION_NAME => c.p72
611: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
612: ,P_EFFECTIVE_DATE => c.p2
613: ,P_LANGUAGE_CODE => c.p73);

Line 621: hr_pump_get.GET_GRADE_ID

617: c.p2 is null then
618: L_GRADE_ID:=nn;
619: else
620: L_GRADE_ID :=
621: hr_pump_get.GET_GRADE_ID
622: (P_GRADE_NAME => c.p74
623: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
624: ,P_EFFECTIVE_DATE => c.p2);
625: end if;

Line 632: hr_pump_get.GET_POSITION_ID

628: c.p2 is null then
629: L_POSITION_ID:=nn;
630: else
631: L_POSITION_ID :=
632: hr_pump_get.GET_POSITION_ID
633: (P_POSITION_NAME => c.p75
634: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
635: ,P_EFFECTIVE_DATE => c.p2);
636: end if;

Line 643: hr_pump_get.GET_JOB_ID

639: c.p2 is null then
640: L_JOB_ID:=nn;
641: else
642: L_JOB_ID :=
643: hr_pump_get.GET_JOB_ID
644: (P_JOB_NAME => c.p76
645: ,P_EFFECTIVE_DATE => c.p2
646: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
647: end if;

Line 654: hr_pump_get.GET_ASSIGNMENT_STATUS_TYPE_ID

650: c.p73 is null then
651: L_ASSIGNMENT_STATUS_TYPE_ID:=nn;
652: else
653: L_ASSIGNMENT_STATUS_TYPE_ID :=
654: hr_pump_get.GET_ASSIGNMENT_STATUS_TYPE_ID
655: (P_USER_STATUS => c.p77
656: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
657: ,P_LANGUAGE_CODE => c.p73);
658: end if;

Line 665: hr_pump_get.GET_PAYROLL_ID

661: c.p2 is null then
662: L_PAYROLL_ID:=nn;
663: else
664: L_PAYROLL_ID :=
665: hr_pump_get.GET_PAYROLL_ID
666: (P_PAYROLL_NAME => c.p78
667: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
668: ,P_EFFECTIVE_DATE => c.p2);
669: end if;

Line 676: hr_pump_get.GET_LOCATION_ID

672: c.p73 is null then
673: L_LOCATION_ID:=nn;
674: else
675: L_LOCATION_ID :=
676: hr_pump_get.GET_LOCATION_ID
677: (P_LOCATION_CODE => c.p79
678: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
679: ,P_LANGUAGE_CODE => c.p73);
680: end if;

Line 686: hr_pump_get.GET_SUPERVISOR_ID

682: if c.p80 is null then
683: L_SUPERVISOR_ID:=nn;
684: else
685: L_SUPERVISOR_ID :=
686: hr_pump_get.GET_SUPERVISOR_ID
687: (P_SUPERVISOR_USER_KEY => c.p80);
688: end if;
689: --
690: if c.p81 is null then

Line 694: hr_pump_get.GET_SPECIAL_CEILING_STEP_ID

690: if c.p81 is null then
691: L_SPECIAL_CEILING_STEP_ID:=nn;
692: else
693: L_SPECIAL_CEILING_STEP_ID :=
694: hr_pump_get.GET_SPECIAL_CEILING_STEP_ID
695: (P_SPECIAL_CEILIN_STEP_USER_KEY => c.p81);
696: end if;
697: --
698: if c.p82 is null or

Line 703: hr_pump_get.GET_PEOPLE_GROUP_ID

699: c.p2 is null then
700: L_PEOPLE_GROUP_ID:=nn;
701: else
702: L_PEOPLE_GROUP_ID :=
703: hr_pump_get.GET_PEOPLE_GROUP_ID
704: (P_PEOPLE_GROUP_USER_NAME => c.p82
705: ,P_EFFECTIVE_DATE => c.p2);
706: end if;
707: --

Line 713: hr_pump_get.GET_SOFT_CODING_KEYFLEX_ID

709: c.p2 is null then
710: L_SOFT_CODING_KEYFLEX_ID:=nn;
711: else
712: L_SOFT_CODING_KEYFLEX_ID :=
713: hr_pump_get.GET_SOFT_CODING_KEYFLEX_ID
714: (P_CON_SEG_USER_NAME => c.p83
715: ,P_EFFECTIVE_DATE => c.p2);
716: end if;
717: --

Line 722: hr_pump_get.GET_PAY_BASIS_ID

718: if c.p84 is null then
719: L_PAY_BASIS_ID:=nn;
720: else
721: L_PAY_BASIS_ID :=
722: hr_pump_get.GET_PAY_BASIS_ID
723: (P_PAY_BASIS_NAME => c.p84
724: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
725: end if;
726: --

Line 731: hr_pump_get.GET_DEFAULT_CODE_COMB_ID

727: if c.p85 is null then
728: L_DEFAULT_CODE_COMB_ID:=nn;
729: else
730: L_DEFAULT_CODE_COMB_ID :=
731: hr_pump_get.GET_DEFAULT_CODE_COMB_ID
732: (P_DEFAULT_CODE_COMB_USER_KEY => c.p85);
733: end if;
734: --
735: if c.p86 is null then

Line 739: hr_pump_get.GET_SET_OF_BOOKS_ID

735: if c.p86 is null then
736: L_SET_OF_BOOKS_ID:=nn;
737: else
738: L_SET_OF_BOOKS_ID :=
739: hr_pump_get.GET_SET_OF_BOOKS_ID
740: (P_SET_OF_BOOKS_NAME => c.p86);
741: end if;
742: --
743: if c.p87 is null or

Line 748: hr_pump_get.GET_PERSON_TYPE_ID

744: c.p73 is null then
745: L_ORIGINAL_PERSON_TYPE:=vn;
746: else
747: L_ORIGINAL_PERSON_TYPE :=
748: hr_pump_get.GET_PERSON_TYPE_ID
749: (P_USER_PERSON_TYPE => c.p87
750: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
751: ,P_LANGUAGE_CODE => c.p73);
752: end if;

Line 759: hr_pump_get.GET_ABSENCE_ATTENDANCE_TYPE_ID

755: c.p2 is null then
756: L_ABSENCE_TYPE:=vn;
757: else
758: L_ABSENCE_TYPE :=
759: hr_pump_get.GET_ABSENCE_ATTENDANCE_TYPE_ID
760: (P_AAT_USER_NAME => c.p88
761: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
762: ,P_EFFECTIVE_DATE => c.p2);
763: end if;