APPS.BEN_BACK_OUT_LIFE_EVENT dependencies on BEN_LER_F

Line 526: ben_ler_f ler

522:
523: cursor c_prev_pil_id is
524: select per_in_ler_id
525: from ben_per_in_ler pil,
526: ben_ler_f ler
527: where pil.per_in_ler_id <> p_per_in_ler_id
528: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
529: and pil.person_id = (select person_id from ben_per_in_ler where
530: per_in_ler_id = p_per_in_ler_id)

Line 1483: from ben_ler_f ler

1479: ;
1480:
1481: cursor c_get_ler_info(v_ler_id number) is
1482: select ler.typ_cd
1483: from ben_ler_f ler
1484: where ler.ler_id = v_ler_id
1485: /* and ler.business_group_id = p_business_group_id*/ -- CWBGLOBAL
1486: and p_effective_date between
1487: ler.effective_start_date and ler.effective_end_date;

Line 1491: from ben_ler_f ler,

1487: ler.effective_start_date and ler.effective_end_date;
1488: --
1489: cursor c_ler_typ is
1490: select ler.typ_cd
1491: from ben_ler_f ler,
1492: ben_per_in_ler pil
1493: where pil.per_in_ler_id = p_per_in_ler_id
1494: and ler.ler_id = pil.ler_id
1495: /*and ler.business_group_id = p_business_group_id*/ --CWBGLOBAL

Line 1544: ben_ler_f ler

1540: cursor c_prv_pil(p_person_id number, p_lf_evt_ocrd_dt date) is
1541: select per_in_ler_id ,
1542: lf_evt_ocrd_dt
1543: from ben_per_in_ler pil,
1544: ben_ler_f ler
1545: where per_in_ler_id <> p_per_in_ler_id
1546: and per_in_ler_stat_cd = 'PROCD'
1547: and person_id = p_person_id
1548: and lf_evt_ocrd_dt <= p_lf_evt_ocrd_dt

Line 3871: ben_ler_f ler

3867: changes which raises APP-PAY-07187 error.So check whether enrolment records exists for previous LE*/
3868: and exists
3869: (select '1' from ben_prtt_enrt_rslt_f pen1,
3870: (select per_in_ler_id from ben_per_in_ler pil,
3871: ben_ler_f ler
3872: where pil.person_id = (select person_id
3873: from ben_per_in_ler pil2
3874: where pil2.per_in_ler_id=p_per_in_ler_id)
3875: and pil.per_in_ler_id <> p_per_in_ler_id