APPS.BEN_ON_LINE_LF_EVT dependencies on BEN_LER_F

Line 487: (name ben_ler_f.name%type,

483: L_RETCODE number;
484: l_package varchar2(80) := g_package||'.p_evt_lf_events';
485: --
486: type l_le_rec is record
487: (name ben_ler_f.name%type,
488: lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type);
489: --
490: type l_le_table is table of l_le_rec
491: index by binary_integer;

Line 529: ben_ler_f ler,

525: pil.lf_evt_ocrd_dt,
526: pil.per_in_ler_stat_cd,
527: pel.dflt_enrt_dt
528: from ben_per_in_ler pil,
529: ben_ler_f ler,
530: ben_pil_elctbl_chc_popl pel
531: where pil.ler_id = ler.ler_id
532: and pil.per_in_ler_id = pel.per_in_ler_id
533: and pil.person_id = l_person_id

Line 557: ben_ler_f ler,

553: pel.dflt_enrt_dt
554: from per_contact_relationships csr, --?? will be _f
555: per_people_f ppf,
556: ben_per_in_ler pil,
557: ben_ler_f ler,
558: ben_pil_elctbl_chc_popl pel
559: where csr.person_id = l_person_id
560: and ppf.person_id = csr.contact_person_id
561: and pil.per_in_ler_id = pel.per_in_ler_id

Line 1069: ben_ler_f ler

1065: select count(*)
1066: from ben_elig_per_elctbl_chc epe,
1067: ben_pil_elctbl_chc_popl pcp,
1068: ben_per_in_ler pil,
1069: ben_ler_f ler
1070: where pil.person_id = to_number(l_person_id)
1071: and pil.per_in_ler_id = pcp.per_in_ler_id
1072: and pcp.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
1073: and ler.ler_id = pil.ler_id

Line 2795: ben_ler_f ler

2791: cursor c_open(p_lf_evt_ocrd_dt date,
2792: p_person_id number ) is
2793: select ler.typ_cd
2794: from ben_ptnl_ler_for_per pel,
2795: ben_ler_f ler
2796: where p_effective_date between ler.effective_start_date
2797: and ler.effective_end_date
2798: and ler.typ_cd in ( 'SCHEDDO','SCHEDDA')
2799: and pel.ptnl_ler_for_per_stat_cd = 'UNPROCD'