APPS.HRDPP_UPDATE_ELIGIBLE_PERSON dependencies on HR_PUMP_GET

Line 427: hr_pump_get.gl(l.pval004,'YES_NO',d(l.pval088),vn)) p4,

423: decode(l.pval002,cn,dn,d(l.pval002)) p2,
424: decode(l.pval003,cn,nn,vn,vn,n(l.pval003)) p3,
425: l.pval003 d3,
426: decode(l.pval004,cn,vn,vn,vh,
427: hr_pump_get.gl(l.pval004,'YES_NO',d(l.pval088),vn)) p4,
428: l.pval004 d4,
429: decode(l.pval005,cn,dn,vn,dh,d(l.pval005)) p5,
430: l.pval005 d5,
431: decode(l.pval006,cn,vn,vn,vh,

Line 432: hr_pump_get.gl(l.pval006,'YES_NO',d(l.pval088),vn)) p6,

428: l.pval004 d4,
429: decode(l.pval005,cn,dn,vn,dh,d(l.pval005)) p5,
430: l.pval005 d5,
431: decode(l.pval006,cn,vn,vn,vh,
432: hr_pump_get.gl(l.pval006,'YES_NO',d(l.pval088),vn)) p6,
433: l.pval006 d6,
434: decode(l.pval007,cn,vn,vn,vh,
435: hr_pump_get.gl(l.pval007,'YES_NO',d(l.pval088),vn)) p7,
436: l.pval007 d7,

Line 435: hr_pump_get.gl(l.pval007,'YES_NO',d(l.pval088),vn)) p7,

431: decode(l.pval006,cn,vn,vn,vh,
432: hr_pump_get.gl(l.pval006,'YES_NO',d(l.pval088),vn)) p6,
433: l.pval006 d6,
434: decode(l.pval007,cn,vn,vn,vh,
435: hr_pump_get.gl(l.pval007,'YES_NO',d(l.pval088),vn)) p7,
436: l.pval007 d7,
437: decode(l.pval008,cn,vn,vn,vh,
438: hr_pump_get.gl(l.pval008,'YES_NO',d(l.pval088),vn)) p8,
439: l.pval008 d8,

Line 438: hr_pump_get.gl(l.pval008,'YES_NO',d(l.pval088),vn)) p8,

434: decode(l.pval007,cn,vn,vn,vh,
435: hr_pump_get.gl(l.pval007,'YES_NO',d(l.pval088),vn)) p7,
436: l.pval007 d7,
437: decode(l.pval008,cn,vn,vn,vh,
438: hr_pump_get.gl(l.pval008,'YES_NO',d(l.pval088),vn)) p8,
439: l.pval008 d8,
440: decode(l.pval009,cn,nn,vn,nh,n(l.pval009)) p9,
441: l.pval009 d9,
442: decode(l.pval010,cn,nn,vn,nh,n(l.pval010)) p10,

Line 457: hr_pump_get.gl(l.pval017,'BEN_WV_PRTN_CTFN_TYP',d(l.pval088),vn)) p17,

453: l.pval015 d15,
454: decode(l.pval016,cn,dn,vn,dh,d(l.pval016)) p16,
455: l.pval016 d16,
456: decode(l.pval017,cn,vn,vn,vh,
457: hr_pump_get.gl(l.pval017,'BEN_WV_PRTN_CTFN_TYP',d(l.pval088),vn)) p17,
458: l.pval017 d17,
459: decode(l.pval018,cn,nn,vn,nh,n(l.pval018)) p18,
460: l.pval018 d18,
461: decode(l.pval019,cn,vn,vn,vh,

Line 462: hr_pump_get.gl(l.pval019,'BEN_BNDRY_PERD',d(l.pval088),vn)) p19,

458: l.pval017 d17,
459: decode(l.pval018,cn,nn,vn,nh,n(l.pval018)) p18,
460: l.pval018 d18,
461: decode(l.pval019,cn,vn,vn,vh,
462: hr_pump_get.gl(l.pval019,'BEN_BNDRY_PERD',d(l.pval088),vn)) p19,
463: l.pval019 d19,
464: decode(l.pval020,cn,vn,vn,vh,
465: hr_pump_get.gl(l.pval020,'YES_NO',d(l.pval088),vn)) p20,
466: l.pval020 d20,

Line 465: hr_pump_get.gl(l.pval020,'YES_NO',d(l.pval088),vn)) p20,

461: decode(l.pval019,cn,vn,vn,vh,
462: hr_pump_get.gl(l.pval019,'BEN_BNDRY_PERD',d(l.pval088),vn)) p19,
463: l.pval019 d19,
464: decode(l.pval020,cn,vn,vn,vh,
465: hr_pump_get.gl(l.pval020,'YES_NO',d(l.pval088),vn)) p20,
466: l.pval020 d20,
467: decode(l.pval021,cn,vn,vn,vh,
468: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval088),vn)) p21,
469: l.pval021 d21,

Line 468: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval088),vn)) p21,

464: decode(l.pval020,cn,vn,vn,vh,
465: hr_pump_get.gl(l.pval020,'YES_NO',d(l.pval088),vn)) p20,
466: l.pval020 d20,
467: decode(l.pval021,cn,vn,vn,vh,
468: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval088),vn)) p21,
469: l.pval021 d21,
470: decode(l.pval022,cn,vn,vn,vh,
471: hr_pump_get.gl(l.pval022,'BEN_OVRID_RSN',d(l.pval088),vn)) p22,
472: l.pval022 d22,

Line 471: hr_pump_get.gl(l.pval022,'BEN_OVRID_RSN',d(l.pval088),vn)) p22,

467: decode(l.pval021,cn,vn,vn,vh,
468: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval088),vn)) p21,
469: l.pval021 d21,
470: decode(l.pval022,cn,vn,vn,vh,
471: hr_pump_get.gl(l.pval022,'BEN_OVRID_RSN',d(l.pval088),vn)) p22,
472: l.pval022 d22,
473: decode(l.pval023,cn,vn,vn,vh,
474: hr_pump_get.gl(l.pval023,'BEN_TM_UOM',d(l.pval088),vn)) p23,
475: l.pval023 d23,

Line 474: hr_pump_get.gl(l.pval023,'BEN_TM_UOM',d(l.pval088),vn)) p23,

470: decode(l.pval022,cn,vn,vn,vh,
471: hr_pump_get.gl(l.pval022,'BEN_OVRID_RSN',d(l.pval088),vn)) p22,
472: l.pval022 d22,
473: decode(l.pval023,cn,vn,vn,vh,
474: hr_pump_get.gl(l.pval023,'BEN_TM_UOM',d(l.pval088),vn)) p23,
475: l.pval023 d23,
476: decode(l.pval024,cn,vn,vn,vh,
477: hr_pump_get.gl(l.pval024,'BEN_TM_UOM',d(l.pval088),vn)) p24,
478: l.pval024 d24,

Line 477: hr_pump_get.gl(l.pval024,'BEN_TM_UOM',d(l.pval088),vn)) p24,

473: decode(l.pval023,cn,vn,vn,vh,
474: hr_pump_get.gl(l.pval023,'BEN_TM_UOM',d(l.pval088),vn)) p23,
475: l.pval023 d23,
476: decode(l.pval024,cn,vn,vn,vh,
477: hr_pump_get.gl(l.pval024,'BEN_TM_UOM',d(l.pval088),vn)) p24,
478: l.pval024 d24,
479: decode(l.pval025,cn,dn,vn,dh,d(l.pval025)) p25,
480: l.pval025 d25,
481: decode(l.pval026,cn,vn,vn,vh,

Line 482: hr_pump_get.gl(l.pval026,'BEN_INELG_RSN',d(l.pval088),vn)) p26,

478: l.pval024 d24,
479: decode(l.pval025,cn,dn,vn,dh,d(l.pval025)) p25,
480: l.pval025 d25,
481: decode(l.pval026,cn,vn,vn,vh,
482: hr_pump_get.gl(l.pval026,'BEN_INELG_RSN',d(l.pval088),vn)) p26,
483: l.pval026 d26,
484: decode(l.pval027,cn,vn,vn,vh,
485: hr_pump_get.gl(l.pval027,'YES_NO',d(l.pval088),vn)) p27,
486: l.pval027 d27,

Line 485: hr_pump_get.gl(l.pval027,'YES_NO',d(l.pval088),vn)) p27,

481: decode(l.pval026,cn,vn,vn,vh,
482: hr_pump_get.gl(l.pval026,'BEN_INELG_RSN',d(l.pval088),vn)) p26,
483: l.pval026 d26,
484: decode(l.pval027,cn,vn,vn,vh,
485: hr_pump_get.gl(l.pval027,'YES_NO',d(l.pval088),vn)) p27,
486: l.pval027 d27,
487: decode(l.pval028,cn,vn,vn,vh,
488: hr_pump_get.gl(l.pval028,'YES_NO',d(l.pval088),vn)) p28,
489: l.pval028 d28,

Line 488: hr_pump_get.gl(l.pval028,'YES_NO',d(l.pval088),vn)) p28,

484: decode(l.pval027,cn,vn,vn,vh,
485: hr_pump_get.gl(l.pval027,'YES_NO',d(l.pval088),vn)) p27,
486: l.pval027 d27,
487: decode(l.pval028,cn,vn,vn,vh,
488: hr_pump_get.gl(l.pval028,'YES_NO',d(l.pval088),vn)) p28,
489: l.pval028 d28,
490: decode(l.pval029,cn,vn,vn,vh,
491: hr_pump_get.gl(l.pval029,'YES_NO',d(l.pval088),vn)) p29,
492: l.pval029 d29,

Line 491: hr_pump_get.gl(l.pval029,'YES_NO',d(l.pval088),vn)) p29,

487: decode(l.pval028,cn,vn,vn,vh,
488: hr_pump_get.gl(l.pval028,'YES_NO',d(l.pval088),vn)) p28,
489: l.pval028 d28,
490: decode(l.pval029,cn,vn,vn,vh,
491: hr_pump_get.gl(l.pval029,'YES_NO',d(l.pval088),vn)) p29,
492: l.pval029 d29,
493: decode(l.pval030,cn,vn,vn,vh,
494: hr_pump_get.gl(l.pval030,'YES_NO',d(l.pval088),vn)) p30,
495: l.pval030 d30,

Line 494: hr_pump_get.gl(l.pval030,'YES_NO',d(l.pval088),vn)) p30,

490: decode(l.pval029,cn,vn,vn,vh,
491: hr_pump_get.gl(l.pval029,'YES_NO',d(l.pval088),vn)) p29,
492: l.pval029 d29,
493: decode(l.pval030,cn,vn,vn,vh,
494: hr_pump_get.gl(l.pval030,'YES_NO',d(l.pval088),vn)) p30,
495: l.pval030 d30,
496: decode(l.pval031,cn,vn,vn,vh,
497: hr_pump_get.gl(l.pval031,'YES_NO',d(l.pval088),vn)) p31,
498: l.pval031 d31,

Line 497: hr_pump_get.gl(l.pval031,'YES_NO',d(l.pval088),vn)) p31,

493: decode(l.pval030,cn,vn,vn,vh,
494: hr_pump_get.gl(l.pval030,'YES_NO',d(l.pval088),vn)) p30,
495: l.pval030 d30,
496: decode(l.pval031,cn,vn,vn,vh,
497: hr_pump_get.gl(l.pval031,'YES_NO',d(l.pval088),vn)) p31,
498: l.pval031 d31,
499: decode(l.pval032,cn,vn,vn,vh,
500: hr_pump_get.gl(l.pval032,'YES_NO',d(l.pval088),vn)) p32,
501: l.pval032 d32,

Line 500: hr_pump_get.gl(l.pval032,'YES_NO',d(l.pval088),vn)) p32,

496: decode(l.pval031,cn,vn,vn,vh,
497: hr_pump_get.gl(l.pval031,'YES_NO',d(l.pval088),vn)) p31,
498: l.pval031 d31,
499: decode(l.pval032,cn,vn,vn,vh,
500: hr_pump_get.gl(l.pval032,'YES_NO',d(l.pval088),vn)) p32,
501: l.pval032 d32,
502: decode(l.pval033,cn,vn,vn,vh,
503: hr_pump_get.gl(l.pval033,'YES_NO',d(l.pval088),vn)) p33,
504: l.pval033 d33,

Line 503: hr_pump_get.gl(l.pval033,'YES_NO',d(l.pval088),vn)) p33,

499: decode(l.pval032,cn,vn,vn,vh,
500: hr_pump_get.gl(l.pval032,'YES_NO',d(l.pval088),vn)) p32,
501: l.pval032 d32,
502: decode(l.pval033,cn,vn,vn,vh,
503: hr_pump_get.gl(l.pval033,'YES_NO',d(l.pval088),vn)) p33,
504: l.pval033 d33,
505: decode(l.pval034,cn,nn,vn,nh,n(l.pval034)) p34,
506: l.pval034 d34,
507: decode(l.pval035,cn,vn,vn,vh,

Line 508: hr_pump_get.gl(l.pval035,'BEN_WV_PRTN_RSN',d(l.pval088),vn)) p35,

504: l.pval033 d33,
505: decode(l.pval034,cn,nn,vn,nh,n(l.pval034)) p34,
506: l.pval034 d34,
507: decode(l.pval035,cn,vn,vn,vh,
508: hr_pump_get.gl(l.pval035,'BEN_WV_PRTN_RSN',d(l.pval088),vn)) p35,
509: l.pval035 d35,
510: decode(l.pval036,cn,vn,vn,vh,
511: hr_pump_get.gl(l.pval036,'YES_NO',d(l.pval088),vn)) p36,
512: l.pval036 d36,

Line 511: hr_pump_get.gl(l.pval036,'YES_NO',d(l.pval088),vn)) p36,

507: decode(l.pval035,cn,vn,vn,vh,
508: hr_pump_get.gl(l.pval035,'BEN_WV_PRTN_RSN',d(l.pval088),vn)) p35,
509: l.pval035 d35,
510: decode(l.pval036,cn,vn,vn,vh,
511: hr_pump_get.gl(l.pval036,'YES_NO',d(l.pval088),vn)) p36,
512: l.pval036 d36,
513: decode(l.pval037,cn,nn,vn,nh,n(l.pval037)) p37,
514: l.pval037 d37,
515: decode(l.pval038,cn,nn,vn,nh,n(l.pval038)) p38,

Line 524: hr_pump_get.gl(l.pval042,'BEN_BNDRY_PERD',d(l.pval088),vn)) p42,

520: l.pval040 d40,
521: decode(l.pval041,cn,nn,vn,nh,n(l.pval041)) p41,
522: l.pval041 d41,
523: decode(l.pval042,cn,vn,vn,vh,
524: hr_pump_get.gl(l.pval042,'BEN_BNDRY_PERD',d(l.pval088),vn)) p42,
525: l.pval042 d42,
526: decode(l.pval043,cn,vn,vn,vh,
527: hr_pump_get.gl(l.pval043,'BEN_TM_UOM',d(l.pval088),vn)) p43,
528: l.pval043 d43,

Line 527: hr_pump_get.gl(l.pval043,'BEN_TM_UOM',d(l.pval088),vn)) p43,

523: decode(l.pval042,cn,vn,vn,vh,
524: hr_pump_get.gl(l.pval042,'BEN_BNDRY_PERD',d(l.pval088),vn)) p42,
525: l.pval042 d42,
526: decode(l.pval043,cn,vn,vn,vh,
527: hr_pump_get.gl(l.pval043,'BEN_TM_UOM',d(l.pval088),vn)) p43,
528: l.pval043 d43,
529: decode(l.pval044,cn,vn,vn,vh,
530: hr_pump_get.gl(l.pval044,'BEN_TM_UOM',d(l.pval088),vn)) p44,
531: l.pval044 d44,

Line 530: hr_pump_get.gl(l.pval044,'BEN_TM_UOM',d(l.pval088),vn)) p44,

526: decode(l.pval043,cn,vn,vn,vh,
527: hr_pump_get.gl(l.pval043,'BEN_TM_UOM',d(l.pval088),vn)) p43,
528: l.pval043 d43,
529: decode(l.pval044,cn,vn,vn,vh,
530: hr_pump_get.gl(l.pval044,'BEN_TM_UOM',d(l.pval088),vn)) p44,
531: l.pval044 d44,
532: decode(l.pval045,cn,nn,vn,nh,n(l.pval045)) p45,
533: l.pval045 d45,
534: decode(l.pval046,cn,vn,vn,vh,

Line 535: hr_pump_get.gl(l.pval046,'YES_NO',d(l.pval088),vn)) p46,

531: l.pval044 d44,
532: decode(l.pval045,cn,nn,vn,nh,n(l.pval045)) p45,
533: l.pval045 d45,
534: decode(l.pval046,cn,vn,vn,vh,
535: hr_pump_get.gl(l.pval046,'YES_NO',d(l.pval088),vn)) p46,
536: l.pval046 d46,
537: decode(l.pval047,cn,vn,vn,vh,
538: hr_pump_get.gl(l.pval047,'YES_NO',d(l.pval088),vn)) p47,
539: l.pval047 d47,

Line 538: hr_pump_get.gl(l.pval047,'YES_NO',d(l.pval088),vn)) p47,

534: decode(l.pval046,cn,vn,vn,vh,
535: hr_pump_get.gl(l.pval046,'YES_NO',d(l.pval088),vn)) p46,
536: l.pval046 d46,
537: decode(l.pval047,cn,vn,vn,vh,
538: hr_pump_get.gl(l.pval047,'YES_NO',d(l.pval088),vn)) p47,
539: l.pval047 d47,
540: decode(l.pval048,cn,vn,vn,vh,
541: hr_pump_get.gl(l.pval048,'YES_NO',d(l.pval088),vn)) p48,
542: l.pval048 d48,

Line 541: hr_pump_get.gl(l.pval048,'YES_NO',d(l.pval088),vn)) p48,

537: decode(l.pval047,cn,vn,vn,vh,
538: hr_pump_get.gl(l.pval047,'YES_NO',d(l.pval088),vn)) p47,
539: l.pval047 d47,
540: decode(l.pval048,cn,vn,vn,vh,
541: hr_pump_get.gl(l.pval048,'YES_NO',d(l.pval088),vn)) p48,
542: l.pval048 d48,
543: decode(l.pval049,cn,vn,vn,vh,
544: hr_pump_get.gl(l.pval049,'YES_NO',d(l.pval088),vn)) p49,
545: l.pval049 d49,

Line 544: hr_pump_get.gl(l.pval049,'YES_NO',d(l.pval088),vn)) p49,

540: decode(l.pval048,cn,vn,vn,vh,
541: hr_pump_get.gl(l.pval048,'YES_NO',d(l.pval088),vn)) p48,
542: l.pval048 d48,
543: decode(l.pval049,cn,vn,vn,vh,
544: hr_pump_get.gl(l.pval049,'YES_NO',d(l.pval088),vn)) p49,
545: l.pval049 d49,
546: decode(l.pval050,cn,vn,vn,vh,
547: hr_pump_get.gl(l.pval050,'YES_NO',d(l.pval088),vn)) p50,
548: l.pval050 d50,

Line 547: hr_pump_get.gl(l.pval050,'YES_NO',d(l.pval088),vn)) p50,

543: decode(l.pval049,cn,vn,vn,vh,
544: hr_pump_get.gl(l.pval049,'YES_NO',d(l.pval088),vn)) p49,
545: l.pval049 d49,
546: decode(l.pval050,cn,vn,vn,vh,
547: hr_pump_get.gl(l.pval050,'YES_NO',d(l.pval088),vn)) p50,
548: l.pval050 d50,
549: decode(l.pval051,cn,vn,vn,vh,
550: hr_pump_get.gl(l.pval051,'YES_NO',d(l.pval088),vn)) p51,
551: l.pval051 d51,

Line 550: hr_pump_get.gl(l.pval051,'YES_NO',d(l.pval088),vn)) p51,

546: decode(l.pval050,cn,vn,vn,vh,
547: hr_pump_get.gl(l.pval050,'YES_NO',d(l.pval088),vn)) p50,
548: l.pval050 d50,
549: decode(l.pval051,cn,vn,vn,vh,
550: hr_pump_get.gl(l.pval051,'YES_NO',d(l.pval088),vn)) p51,
551: l.pval051 d51,
552: decode(l.pval052,cn,vn,vn,vh,
553: hr_pump_get.gl(l.pval052,'BEN_ONCE_R_CNTUG',d(l.pval088),vn)) p52,
554: l.pval052 d52,

Line 553: hr_pump_get.gl(l.pval052,'BEN_ONCE_R_CNTUG',d(l.pval088),vn)) p52,

549: decode(l.pval051,cn,vn,vn,vh,
550: hr_pump_get.gl(l.pval051,'YES_NO',d(l.pval088),vn)) p51,
551: l.pval051 d51,
552: decode(l.pval052,cn,vn,vn,vh,
553: hr_pump_get.gl(l.pval052,'BEN_ONCE_R_CNTUG',d(l.pval088),vn)) p52,
554: l.pval052 d52,
555: decode(l.pval053,cn,nn,vn,nh,n(l.pval053)) p53,
556: l.pval053 d53,
557: decode(l.pval054,cn,nn,vn,nh,n(l.pval054)) p54,

Line 679: hr_pump_get.get_elig_per_id

675: if c.p90 is null then
676: L_ELIG_PER_ID:=nn;
677: else
678: L_ELIG_PER_ID :=
679: hr_pump_get.get_elig_per_id
680: (P_ELIG_PER_USER_KEY => c.p90);
681: end if;
682: --
683: if c.d91=cn or

Line 690: hr_pump_get.GET_PL_ID

686: elsif c.d91 is null then
687: L_PL_ID:=nh;
688: else
689: L_PL_ID :=
690: hr_pump_get.GET_PL_ID
691: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
692: ,P_PLAN => c.p91
693: ,P_EFFECTIVE_DATE => c.p88);
694: end if;

Line 703: hr_pump_get.GET_PGM_ID

699: elsif c.d92 is null then
700: L_PGM_ID:=nh;
701: else
702: L_PGM_ID :=
703: hr_pump_get.GET_PGM_ID
704: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
705: ,P_PROGRAM => c.p92
706: ,P_EFFECTIVE_DATE => c.p88);
707: end if;

Line 715: hr_pump_get.get_plip_id

711: elsif c.d93 is null then
712: L_PLIP_ID:=nh;
713: else
714: L_PLIP_ID :=
715: hr_pump_get.get_plip_id
716: (P_PLIP_USER_KEY => c.p93);
717: end if;
718: --
719: if c.d94=cn then

Line 725: hr_pump_get.GET_PTIP_ID

721: elsif c.d94 is null then
722: L_PTIP_ID:=nh;
723: else
724: L_PTIP_ID :=
725: hr_pump_get.GET_PTIP_ID
726: (P_PTIP_USER_KEY => c.p94);
727: end if;
728: --
729: if c.d95=cn or

Line 736: hr_pump_get.GET_LER_ID

732: elsif c.d95 is null then
733: L_LER_ID:=nh;
734: else
735: L_LER_ID :=
736: hr_pump_get.GET_LER_ID
737: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
738: ,P_LIFE_EVENT_REASON => c.p95
739: ,P_EFFECTIVE_DATE => c.p88);
740: end if;

Line 748: hr_pump_get.get_person_id

744: elsif c.d96 is null then
745: L_PERSON_ID:=nh;
746: else
747: L_PERSON_ID :=
748: hr_pump_get.get_person_id
749: (P_PERSON_USER_KEY => c.p96);
750: end if;
751: --
752: if c.d97=cn or

Line 759: hr_pump_get.GET_COMP_REF_UOM_CODE

755: elsif c.d97 is null then
756: L_COMP_REF_UOM:=vh;
757: else
758: L_COMP_REF_UOM :=
759: hr_pump_get.GET_COMP_REF_UOM_CODE
760: (P_COMP_REF_UOM => c.p97
761: ,P_EFFECTIVE_DATE => c.p88);
762: end if;
763: --

Line 771: hr_pump_get.GET_RT_COMP_REF_UOM_CODE

767: elsif c.d98 is null then
768: L_RT_COMP_REF_UOM:=vh;
769: else
770: L_RT_COMP_REF_UOM :=
771: hr_pump_get.GET_RT_COMP_REF_UOM_CODE
772: (P_RT_COMP_REF_UOM => c.p98
773: ,P_EFFECTIVE_DATE => c.p88);
774: end if;
775: --

Line 777: hr_pump_get.get_request_id;

773: ,P_EFFECTIVE_DATE => c.p88);
774: end if;
775: --
776: L_REQUEST_ID :=
777: hr_pump_get.get_request_id;
778: --
779: L_PROGRAM_APPLICATION_ID :=
780: hr_pump_get.get_program_application_id;
781: --

Line 780: hr_pump_get.get_program_application_id;

776: L_REQUEST_ID :=
777: hr_pump_get.get_request_id;
778: --
779: L_PROGRAM_APPLICATION_ID :=
780: hr_pump_get.get_program_application_id;
781: --
782: L_PROGRAM_ID :=
783: hr_pump_get.get_program_id;
784: --

Line 783: hr_pump_get.get_program_id;

779: L_PROGRAM_APPLICATION_ID :=
780: hr_pump_get.get_program_application_id;
781: --
782: L_PROGRAM_ID :=
783: hr_pump_get.get_program_id;
784: --
785: if c.p90 is null or
786: c.p88 is null then
787: L_OBJECT_VERSION_NUMBER:=nn;

Line 790: hr_pump_get.GET_ELIG_PER_OVN

786: c.p88 is null then
787: L_OBJECT_VERSION_NUMBER:=nn;
788: else
789: L_OBJECT_VERSION_NUMBER :=
790: hr_pump_get.GET_ELIG_PER_OVN
791: (P_ELIG_PER_USER_KEY => c.p90
792: ,P_EFFECTIVE_DATE => c.p88);
793: end if;
794: --