APPS.BEN_ON_LINE_LF_EVT dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 530: ben_pil_elctbl_chc_popl pel

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
534: and pil.business_group_id = l_business_group_id

Line 558: ben_pil_elctbl_chc_popl pel

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
562: /* and l_effective_date

Line 1067: ben_pil_elctbl_chc_popl pcp,

1063: --
1064: cursor c_elctbl_chc is
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

Line 1456: from BEN_PIL_ELCTBL_CHC_POPL

1452:
1453: -- start bug 4430107
1454: cursor c_pgm is
1455: select pgm_id
1456: from BEN_PIL_ELCTBL_CHC_POPL
1457: where business_group_id = p_business_group_id
1458: and PER_IN_LER_ID = l_rec.per_in_ler_id
1459: and pgm_id is not null;
1460: --

Line 2876: from ben_pil_elctbl_chc_popl pel

2872: if p_mode = 'U' then
2873: declare
2874: cursor c_popl_lock(p_per_in_ler_id number) is
2875: select null
2876: from ben_pil_elctbl_chc_popl pel
2877: where per_in_ler_id = p_per_in_ler_id
2878: for update nowait;
2879: l_test number;
2880: