APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 862: from ben_pil_elctbl_chc_popl popl,

858: and pep.elig_per_id = p_elig_per_id ;
859: --
860: cursor c_epe_pgm(p_pgm_id number,p_pl_id number) IS
861: select epe.fonm_cvg_strt_dt
862: from ben_pil_elctbl_chc_popl popl,
863: ben_elig_per_elctbl_chc epe
864: where popl.per_in_ler_id = p_per_in_ler_id
865: and popl.pgm_id = p_pgm_id
866: and epe.pil_elctbl_chc_popl_id = popl.pil_elctbl_chc_popl_id

Line 871: from ben_pil_elctbl_chc_popl popl,

867: and NVL(epe.pl_id,-1) = nvl(p_pl_id, nvl(epe.pl_id,-1)); -- 5633934 : Added this condition
868: --
869: cursor c_epe_pl(p_pl_id number) IS
870: select epe.fonm_cvg_strt_dt
871: from ben_pil_elctbl_chc_popl popl,
872: ben_elig_per_elctbl_chc epe
873: where popl.per_in_ler_id = p_per_in_ler_id
874: and popl.pl_id = p_pl_id
875: and epe.pil_elctbl_chc_popl_id = popl.pil_elctbl_chc_popl_id;

Line 2102: ben_pil_elctbl_chc_popl pel

2098: ctu.pgm_id,
2099: ctu.pl_typ_id
2100: from ben_cm_typ_usg_f ctu,
2101: ben_prtt_enrt_rslt_f pen,
2102: ben_pil_elctbl_chc_popl pel
2103: where ctu.business_group_id = p_business_group_id
2104: /* First join comp objects */
2105: and pen.business_group_id = ctu.business_group_id
2106: and pen.per_in_ler_id = p_per_in_ler_id

Line 2269: ben_pil_elctbl_chc_popl pel

2265: ctu.pgm_id,
2266: ctu.pl_typ_id
2267: from ben_cm_typ_usg_f ctu,
2268: ben_prtt_enrt_rslt_f pen,
2269: ben_pil_elctbl_chc_popl pel
2270: where ctu.business_group_id = p_business_group_id
2271: /* First join comp objects */
2272: and pen.business_group_id = ctu.business_group_id
2273: and pen.per_in_ler_id = p_per_in_ler_id

Line 2893: ben_pil_elctbl_chc_popl pel

2889: cursor c1 is
2890: select ctu.cm_typ_usg_id,
2891: ctu.cm_usg_rl
2892: from ben_cm_typ_usg_f ctu,
2893: ben_pil_elctbl_chc_popl pel
2894: where ctu.business_group_id = p_business_group_id
2895: and pel.business_group_id = ctu.business_group_id
2896: and (p_ler_id is null or
2897: nvl(ctu.ler_id,p_ler_id) = p_ler_id)