APPS.BEN_PEP_CACHE dependencies on BEN_PER_IN_LER

Line 31: 115.11 28-Jul-02 mhoyes - Added back in join to ben_per_in_ler for

27: 115.9 12-Jul-02 mhoyes - Added get_curroiplippep_dets and
28: get_currplnpep_dets.
29: 115.10 16-Jul-02 mhoyes - Fixed oipl electability problem introduced
30: in 115.8.
31: 115.11 28-Jul-02 mhoyes - Added back in join to ben_per_in_ler for
32: voided and backed out life events in
33: get_pilplnpep_dets.
34: 115.12 20-Aug-02 mhoyes - Added caching into get_currpepepo_dets based
35: on comp object list row values.

Line 331: ben_per_in_ler pil

327: pep.must_enrl_anthr_pl_id,
328: pep.prtn_strt_dt,
329: pep.inelg_rsn_cd
330: FROM ben_elig_per_f pep,
331: ben_per_in_ler pil
332: WHERE pep.per_in_ler_id = c_per_in_ler_id
333: AND pep.pl_id = c_pl_id
334: AND pep.pgm_id = c_pgm_id
335: AND c_effective_date

Line 359: ben_per_in_ler pil

355: pep.must_enrl_anthr_pl_id,
356: pep.prtn_strt_dt,
357: pep.inelg_rsn_cd
358: FROM ben_elig_per_f pep,
359: ben_per_in_ler pil
360: WHERE pep.per_in_ler_id = c_per_in_ler_id
361: AND pep.pl_id = c_pl_id
362: AND pep.pgm_id IS NULL
363: AND c_effective_date

Line 392: ben_per_in_ler pil

388: epo.prtn_strt_dt,
389: epo.inelg_rsn_cd
390: FROM ben_elig_per_f ep,
391: ben_elig_per_opt_f epo,
392: ben_per_in_ler pil
393: WHERE ep.per_in_ler_id = c_per_in_ler_id
394: AND ep.pl_id = c_pl_id
395: AND ep.pgm_id = c_pgm_id
396: AND c_effective_date

Line 426: ben_per_in_ler pil

422: epo.prtn_strt_dt,
423: epo.inelg_rsn_cd
424: FROM ben_elig_per_f ep,
425: ben_elig_per_opt_f epo,
426: ben_per_in_ler pil
427: WHERE ep.per_in_ler_id = c_per_in_ler_id
428: AND ep.pl_id = c_pl_id
429: AND ep.pgm_id IS NULL
430: AND c_effective_date

Line 565: ben_per_in_ler pil

561: is
562: select /*+ benpepch.get_curroiplippep_dets.c_oiplip_dets */
563: pep.elig_per_id
564: from ben_elig_per_f pep,
565: ben_per_in_ler pil
566: where pep.person_id = c_person_id
567: and pep.pgm_id = c_pgm_id
568: and pep.plip_id = c_plip_id
569: and c_effective_date

Line 586: ben_per_in_ler pil

582: is
583: select /*+ benpepch.get_curroiplippep_dets.c_oiplipnip_dets */
584: pep.elig_per_id
585: from ben_elig_per_f pep,
586: ben_per_in_ler pil
587: where pep.person_id = c_person_id
588: and pep.pgm_id is null
589: and pep.plip_id = c_plip_id
590: and c_effective_date

Line 656: ben_per_in_ler pil

652: pep.elig_per_id,
653: pep.prtn_strt_dt,
654: pep.prtn_end_dt
655: from ben_elig_per_f pep,
656: ben_per_in_ler pil
657: where pep.person_id = c_person_id
658: and pep.pgm_id = c_pgm_id
659: and pep.pl_id = c_pl_id
660: and c_effective_date

Line 679: ben_per_in_ler pil

675: pep.elig_per_id,
676: pep.prtn_strt_dt,
677: pep.prtn_end_dt
678: from ben_elig_per_f pep,
679: ben_per_in_ler pil
680: where pep.person_id = c_person_id
681: and pep.pgm_id is null
682: and pep.pl_id = c_pl_id
683: and c_effective_date