APPS.BEN_MANAGE_CWB_LIFE_EVENTS dependencies on BEN_LER_F

Line 1289: ben_ler_f ler,

1285: -- Bug 5232223
1286: group_pln.trk_inelig_per_flag
1287: from ben_popl_enrt_typ_cycl_f pet,
1288: ben_enrt_perd enp,
1289: ben_ler_f ler,
1290: ben_pl_f pln,
1291: ben_pl_f group_pln
1292: where enp.asnd_lf_evt_dt = cv_lf_evt_ocrd_dt
1293: and enp.popl_enrt_typ_cycl_id = pet.popl_enrt_typ_cycl_id

Line 1333: ben_ler_f ler,

1329: -- Bug 5232223
1330: group_pln.trk_inelig_per_flag
1331: from ben_popl_enrt_typ_cycl_f pet,
1332: ben_enrt_perd enp,
1333: ben_ler_f ler,
1334: ben_pl_f group_pln
1335: where enp.asnd_lf_evt_dt = cv_lf_evt_ocrd_dt
1336: and enp.popl_enrt_typ_cycl_id = pet.popl_enrt_typ_cycl_id
1337: -- and pet.business_group_id = enp.business_group_id

Line 1587: ben_ler_f ler

1583: enrtp.pos_structure_version_id,
1584: enrtp.enrt_perd_det_ovrlp_bckdt_cd
1585: FROM ben_popl_enrt_typ_cycl_f petc,
1586: ben_enrt_perd enrtp,
1587: ben_ler_f ler
1588: WHERE petc.pl_id = l_pl_id
1589: AND petc.business_group_id = p_business_group_id
1590: AND l_lf_evt_ocrd_dt BETWEEN petc.effective_start_date
1591: AND petc.effective_end_date

Line 1938: ben_ler_f ler

1934: cv_pl_id number) is
1935: select ler.ler_id
1936: from ben_popl_enrt_typ_cycl_f pet,
1937: ben_enrt_perd enp,
1938: ben_ler_f ler
1939: where enp.business_group_id = cv_business_group_id
1940: and enp.asnd_lf_evt_dt = cv_lf_evt_ocrd_dt
1941: and enp.popl_enrt_typ_cycl_id = pet.popl_enrt_typ_cycl_id
1942: and pet.business_group_id = enp.business_group_id

Line 2599: ben_ler_f ler

2595: cv_pl_id in number) is
2596: select ler.ler_id
2597: from ben_popl_enrt_typ_cycl_f pet,
2598: ben_enrt_perd enp,
2599: ben_ler_f ler
2600: where enp.business_group_id = cv_business_group_id
2601: and enp.asnd_lf_evt_dt = cv_lf_evt_ocrd_dt
2602: and enp.popl_enrt_typ_cycl_id = pet.popl_enrt_typ_cycl_id
2603: and pet.business_group_id = enp.business_group_id