APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_LER_F

Line 1177: ben_ler_f ler

1173: is
1174: cursor c_prev_pil(c_per_in_ler_id number ) is
1175: select pil.per_in_ler_id
1176: from ben_per_in_ler pil,
1177: ben_ler_f ler
1178: where pil.per_in_ler_id not in (c_per_in_ler_id)
1179: and pil.person_id = p_person_id
1180: and pil.ler_id = ler.ler_id
1181: and p_effective_date between

Line 1944: from ben_ler_f ler

1940:
1941: -- GSP Rate Sync
1942: cursor c_gsp_rate_sync_ler is
1943: select null
1944: from ben_ler_f ler
1945: where ler.typ_cd = 'GSP'
1946: and ler.lf_evt_oper_cd = 'SYNC'
1947: and ler.business_group_id = p_business_group_id
1948: and p_effective_date between ler.effective_start_date

Line 5515: ben_ler_f ler

5511: --
5512: cursor c_potential (p_person_id number) is
5513: select ptnl_ler_for_per_id
5514: from ben_ptnl_ler_for_per pfl,
5515: ben_ler_f ler
5516: where pfl.ptnl_ler_for_per_stat_cd not in ('VOIDD','PROCD')
5517: and pfl.person_id = p_person_id
5518: and pfl.ler_id = ler.ler_id
5519: and p_effective_date

Line 5529: ben_ler_f ler

5525:
5526: cursor c_pil (p_person_id number) is
5527: select 'x'
5528: from ben_per_in_ler pil,
5529: ben_ler_f ler
5530: where pil.per_in_ler_stat_cd = 'STRTD'
5531: and pil.person_id = p_person_id
5532: and pil.ler_id = ler.ler_id
5533: and p_effective_date between ler.effective_start_date

Line 7850: ben_ler_f ler

7846: cursor c_popl_enrt_typ_cycl is
7847: select ler.ler_id, pet.popl_enrt_typ_cycl_id
7848: from ben_popl_enrt_typ_cycl_f pet,
7849: ben_enrt_perd enp,
7850: ben_ler_f ler
7851: where enp.business_group_id = p_business_group_id
7852: -- PB : 5422 :
7853: and enp.asnd_lf_evt_dt = l_lf_evt_ocrd_dt
7854: -- and enp.enrt_perd_id = p_popl_enrt_typ_cycl_id

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

9333: p_gsp_eval_elig_flag in varchar2 default null, /* GSP Rate Sync */
9334: p_lf_evt_oper_cd in varchar2 default null) is /* GSP Rate Sync */
9335: --
9336: l_package varchar2(80);
9337: l_created_ler_id ben_ler_f.ler_id%type := null;
9338: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
9339: l_ptnl_ler benutils.g_ptnl_ler;
9340: l_effective_start_date date;
9341: l_effective_end_date date;

Line 10507: ben_ler_f ler

10503: enrtp.enrt_perd_id,
10504: NVL(enrtp.defer_deenrol_flag,'N')
10505: FROM ben_popl_enrt_typ_cycl_f petc,
10506: ben_enrt_perd enrtp,
10507: ben_ler_f ler
10508: WHERE petc.pl_id = c_pl_id
10509: AND petc.business_group_id = p_business_group_id
10510: AND c_effective_date BETWEEN petc.effective_start_date
10511: AND petc.effective_end_date

Line 10527: ben_ler_f ler

10523: enrtp.enrt_perd_id,
10524: NVL(enrtp.defer_deenrol_flag,'N')
10525: FROM ben_popl_enrt_typ_cycl_f petc,
10526: ben_enrt_perd enrtp,
10527: ben_ler_f ler
10528: WHERE petc.pgm_id = c_pgm_id
10529: AND petc.business_group_id = p_business_group_id
10530: AND c_effective_date BETWEEN petc.effective_start_date
10531: AND petc.effective_end_date

Line 10548: ben_ler_f ler

10544:
10545: cursor c_get_unres_per_in_ler is
10546: select pil.per_in_ler_id
10547: from ben_per_in_ler pil,
10548: ben_ler_f ler
10549: where pil.person_id = p_person_id
10550: and pil.business_group_id = p_business_group_id
10551: and ler.ler_id = pil.ler_id
10552: and ler.business_group_id = pil.business_group_id

Line 12742: ben_ler_f ler

12738: pil.object_version_number,
12739: pil.ptnl_ler_for_per_id,
12740: ler.qualg_evt_flag
12741: from ben_per_in_ler pil,
12742: ben_ler_f ler
12743: where pil.person_id = p_person_id
12744: and ler.ler_id = pil.ler_id
12745: and p_effective_date
12746: between ler.effective_start_date