APPS.BEN_MANAGE_CWB_LIFE_EVENTS dependencies on BEN_LER_F

Line 1319: ben_ler_f ler,

1315: -- Bug 5232223
1316: group_pln.trk_inelig_per_flag
1317: from ben_popl_enrt_typ_cycl_f pet,
1318: ben_enrt_perd enp,
1319: ben_ler_f ler,
1320: ben_pl_f pln,
1321: ben_pl_f group_pln
1322: where enp.asnd_lf_evt_dt = cv_lf_evt_ocrd_dt
1323: and enp.popl_enrt_typ_cycl_id = pet.popl_enrt_typ_cycl_id

Line 1363: ben_ler_f ler,

1359: -- Bug 5232223
1360: group_pln.trk_inelig_per_flag
1361: from ben_popl_enrt_typ_cycl_f pet,
1362: ben_enrt_perd enp,
1363: ben_ler_f ler,
1364: ben_pl_f group_pln
1365: where enp.asnd_lf_evt_dt = cv_lf_evt_ocrd_dt
1366: and enp.popl_enrt_typ_cycl_id = pet.popl_enrt_typ_cycl_id
1367: -- and pet.business_group_id = enp.business_group_id

Line 1632: ben_ler_f ler

1628: enrtp.pos_structure_version_id,
1629: enrtp.enrt_perd_det_ovrlp_bckdt_cd
1630: FROM ben_popl_enrt_typ_cycl_f petc,
1631: ben_enrt_perd enrtp,
1632: ben_ler_f ler
1633: WHERE petc.pl_id = l_pl_id
1634: AND petc.business_group_id = p_business_group_id
1635: AND l_lf_evt_ocrd_dt BETWEEN petc.effective_start_date
1636: AND petc.effective_end_date

Line 1983: ben_ler_f ler

1979: cv_pl_id number) is
1980: select ler.ler_id
1981: from ben_popl_enrt_typ_cycl_f pet,
1982: ben_enrt_perd enp,
1983: ben_ler_f ler
1984: where enp.business_group_id = cv_business_group_id
1985: and enp.asnd_lf_evt_dt = cv_lf_evt_ocrd_dt
1986: and enp.popl_enrt_typ_cycl_id = pet.popl_enrt_typ_cycl_id
1987: and pet.business_group_id = enp.business_group_id

Line 2644: ben_ler_f ler

2640: cv_pl_id in number) is
2641: select ler.ler_id
2642: from ben_popl_enrt_typ_cycl_f pet,
2643: ben_enrt_perd enp,
2644: ben_ler_f ler
2645: where enp.business_group_id = cv_business_group_id
2646: and enp.asnd_lf_evt_dt = cv_lf_evt_ocrd_dt
2647: and enp.popl_enrt_typ_cycl_id = pet.popl_enrt_typ_cycl_id
2648: and pet.business_group_id = enp.business_group_id