APPS.HRI_OPL_BEN_DIM_REFRESH dependencies on BEN_ENRT_PERD

Line 119: FROM ben_popl_enrt_typ_cycl_f pet, ben_enrt_perd enp

115: AND pgm.effective_end_date
116: AND pgm.pgm_typ_cd IN ('CORE', 'FLEX', 'FPC', 'OTHER')
117: AND EXISTS (
118: SELECT 'x'
119: FROM ben_popl_enrt_typ_cycl_f pet, ben_enrt_perd enp
120: WHERE pet.pgm_id = pgm.pgm_id
121: AND pet.enrt_typ_cycl_cd = 'O'
122: AND l_effective_date BETWEEN pet.effective_start_date
123: AND pet.effective_end_date

Line 225: ben_enrt_perd enp

221: IS
222: SELECT enp.enrt_perd_id, pgmd.pgm_id, enp.strt_dt, enp.end_dt, enp.ASND_LF_EVT_DT ASND_LF_EVT_DT
223: FROM hri_cs_co_pgm_ct pgmd,
224: ben_popl_enrt_typ_cycl_f pet,
225: ben_enrt_perd enp
226: WHERE pgmd.pgm_id = pet.pgm_id
227: AND pet.popl_enrt_typ_cycl_id = enp.popl_enrt_typ_cycl_id
228: AND l_effective_date BETWEEN pet.effective_start_date
229: AND pet.effective_end_date

Line 241: ben_enrt_perd enp

237: enp.asnd_lf_evt_dt ASND_LF_EVT_DT
238: FROM hri_cs_time_benrl_prd_ct enpd,
239: ben_plip_f cpp,
240: ben_popl_enrt_typ_cycl_f pet,
241: ben_enrt_perd enp
242: WHERE enpd.pgm_id = cpp.pgm_id
243: AND pet.pl_id = cpp.pl_id
244: AND pet.popl_enrt_typ_cycl_id = enp.popl_enrt_typ_cycl_id
245: AND enpd.ASND_LF_EVT_DT = enp.asnd_lf_evt_dt

Line 585: FROM ben_enrt_perd enp

581: -- Enrollment Period Dimension
582: --
583: DELETE FROM HRI_CS_TIME_BENRL_PRD_CT enpd
584: WHERE NOT EXISTS (SELECT 'x'
585: FROM ben_enrt_perd enp
586: WHERE enp.enrt_perd_id = enpd.enrt_perd_id);
587: --
588: -- Reporting Group Dimension
589: --

Line 632: FROM ben_popl_enrt_typ_cycl_f pet, ben_enrt_perd enp

628: AND pgm.effective_end_date
629: AND pgm.pgm_typ_cd in ('CORE', 'FLEX', 'FPC', 'OTHER')
630: AND EXISTS (
631: SELECT 'x'
632: FROM ben_popl_enrt_typ_cycl_f pet, ben_enrt_perd enp
633: WHERE pet.pgm_id = pgm.pgm_id
634: AND pet.enrt_typ_cycl_cd = 'O'
635: AND l_effective_date BETWEEN pet.effective_start_date
636: AND pet.effective_end_date

Line 721: ben_enrt_perd enp

717: IS
718: SELECT enp.enrt_perd_id, pgmd.pgm_id, enp.strt_dt, enp.end_dt, enp.ASND_LF_EVT_DT ASND_LF_EVT_DT
719: FROM hri_cs_co_pgm_ct pgmd,
720: ben_popl_enrt_typ_cycl_f pet,
721: ben_enrt_perd enp
722: WHERE pgmd.pgm_id = pet.pgm_id
723: AND pet.popl_enrt_typ_cycl_id = enp.popl_enrt_typ_cycl_id
724: AND l_effective_date BETWEEN pet.effective_start_date
725: AND pet.effective_end_date;

Line 734: ben_enrt_perd enp

730: enp.asnd_lf_evt_dt ASND_LF_EVT_DT
731: FROM hri_cs_time_benrl_prd_ct enpd,
732: ben_plip_f cpp,
733: ben_popl_enrt_typ_cycl_f pet,
734: ben_enrt_perd enp
735: WHERE enpd.pgm_id = cpp.pgm_id
736: AND pet.pl_id = cpp.pl_id
737: AND pet.popl_enrt_typ_cycl_id = enp.popl_enrt_typ_cycl_id
738: AND enpd.ASND_LF_EVT_DT = enp.asnd_lf_evt_dt