APPS.BEN_PRV_BUS dependencies on BEN_ENRT_BNFT

Line 972: from ben_enrt_bnft enb

968: l_c1 c1%rowtype;
969:
970: cursor c2 (p_enrt_bnft_id number) is
971: select enb.elig_per_elctbl_chc_id
972: from ben_enrt_bnft enb
973: where enb.enrt_bnft_id = p_enrt_bnft_id;
974:
975: cursor c3 (p_elig_per_elctbl_chc_id number) is
976: select pil.person_id

Line 989: ben_enrt_bnft enb

985: enb.elig_per_elctbl_chc_id,
986: ecr.elig_per_elctbl_chc_id
987: )
988: from ben_enrt_rt ecr,
989: ben_enrt_bnft enb
990: where ecr.enrt_rt_id = p_enrt_rt_id and
991: enb.enrt_bnft_id(+) = ecr.enrt_bnft_id;
992:
993: cursor c_pln

Line 1247: ben_enrt_bnft enb

1243: enb.elig_per_elctbl_chc_id,
1244: ecr.elig_per_elctbl_chc_id
1245: )
1246: from ben_enrt_rt ecr,
1247: ben_enrt_bnft enb
1248: where ecr.enrt_rt_id = p_enrt_rt_id and
1249: enb.enrt_bnft_id (+) = ecr.enrt_bnft_id;
1250:
1251: cursor c_pln