APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_LER_F

Line 1552: from ben_ler_f ler

1548:
1549: -- GSP Rate Sync
1550: cursor c_gsp_rate_sync_ler is
1551: select null
1552: from ben_ler_f ler
1553: where ler.typ_cd = 'GSP'
1554: and ler.lf_evt_oper_cd = 'SYNC'
1555: and ler.business_group_id = p_business_group_id
1556: and p_effective_date between ler.effective_start_date

Line 5123: ben_ler_f ler

5119: --
5120: cursor c_potential (p_person_id number) is
5121: select ptnl_ler_for_per_id
5122: from ben_ptnl_ler_for_per pfl,
5123: ben_ler_f ler
5124: where pfl.ptnl_ler_for_per_stat_cd not in ('VOIDD','PROCD')
5125: and pfl.person_id = p_person_id
5126: and pfl.ler_id = ler.ler_id
5127: and p_effective_date

Line 5137: ben_ler_f ler

5133:
5134: cursor c_pil (p_person_id number) is
5135: select 'x'
5136: from ben_per_in_ler pil,
5137: ben_ler_f ler
5138: where pil.per_in_ler_stat_cd = 'STRTD'
5139: and pil.person_id = p_person_id
5140: and pil.ler_id = ler.ler_id
5141: and p_effective_date between ler.effective_start_date

Line 7444: ben_ler_f ler

7440: cursor c_popl_enrt_typ_cycl is
7441: select ler.ler_id, pet.popl_enrt_typ_cycl_id
7442: from ben_popl_enrt_typ_cycl_f pet,
7443: ben_enrt_perd enp,
7444: ben_ler_f ler
7445: where enp.business_group_id = p_business_group_id
7446: -- PB : 5422 :
7447: and enp.asnd_lf_evt_dt = l_lf_evt_ocrd_dt
7448: -- and enp.enrt_perd_id = p_popl_enrt_typ_cycl_id

Line 8929: l_created_ler_id ben_ler_f.ler_id%type := null;

8925: p_gsp_eval_elig_flag in varchar2 default null, /* GSP Rate Sync */
8926: p_lf_evt_oper_cd in varchar2 default null) is /* GSP Rate Sync */
8927: --
8928: l_package varchar2(80);
8929: l_created_ler_id ben_ler_f.ler_id%type := null;
8930: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
8931: l_ptnl_ler benutils.g_ptnl_ler;
8932: l_effective_start_date date;
8933: l_effective_end_date date;

Line 10051: ben_ler_f ler

10047: enrtp.enrt_perd_id,
10048: NVL(enrtp.defer_deenrol_flag,'N')
10049: FROM ben_popl_enrt_typ_cycl_f petc,
10050: ben_enrt_perd enrtp,
10051: ben_ler_f ler
10052: WHERE petc.pl_id = c_pl_id
10053: AND petc.business_group_id = p_business_group_id
10054: AND c_effective_date BETWEEN petc.effective_start_date
10055: AND petc.effective_end_date

Line 10071: ben_ler_f ler

10067: enrtp.enrt_perd_id,
10068: NVL(enrtp.defer_deenrol_flag,'N')
10069: FROM ben_popl_enrt_typ_cycl_f petc,
10070: ben_enrt_perd enrtp,
10071: ben_ler_f ler
10072: WHERE petc.pgm_id = c_pgm_id
10073: AND petc.business_group_id = p_business_group_id
10074: AND c_effective_date BETWEEN petc.effective_start_date
10075: AND petc.effective_end_date