DBA Data[Home] [Help]

APPS.BEN_ON_LINE_LF_EVT dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 1066: from ben_elig_per_elctbl_chc epe,

1062: l_can_prtcpnt_enroll char(1);
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)

Line 1190: from ben_elig_per_elctbl_chc epe,

1186: l_can_prtcpnt_enroll char(1);
1187: --
1188: cursor c_elctbl_chc is
1189: select count(*)
1190: from ben_elig_per_elctbl_chc epe,
1191: ben_per_in_ler pil
1192: where pil.person_id = to_number(l_person_id)
1193: and epe.business_group_id+0 = to_number(l_business_group_id)
1194: and epe.PER_IN_LER_ID = pil.PER_IN_LER_ID