APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 998: from ben_pil_elctbl_chc_popl popl,

994: and pep.elig_per_id = p_elig_per_id ;
995: --
996: cursor c_epe_pgm(p_pgm_id number,p_pl_id number) IS
997: select epe.fonm_cvg_strt_dt
998: from ben_pil_elctbl_chc_popl popl,
999: ben_elig_per_elctbl_chc epe
1000: where popl.per_in_ler_id = p_per_in_ler_id
1001: and popl.pgm_id = p_pgm_id
1002: and epe.pil_elctbl_chc_popl_id = popl.pil_elctbl_chc_popl_id

Line 1004: and not exists (select 'x' from ben_pil_elctbl_chc_popl popl1, ben_elig_per_elctbl_chc epe1

1000: where popl.per_in_ler_id = p_per_in_ler_id
1001: and popl.pgm_id = p_pgm_id
1002: and epe.pil_elctbl_chc_popl_id = popl.pil_elctbl_chc_popl_id
1003: and NVL(epe.pl_id,-1) = nvl(p_pl_id, nvl(epe.pl_id,-1)) -- 5633934 : Added this condition
1004: and not exists (select 'x' from ben_pil_elctbl_chc_popl popl1, ben_elig_per_elctbl_chc epe1
1005: where popl1.per_in_ler_id = p_per_in_ler_id
1006: and popl1.pgm_id = p_pgm_id
1007: and epe1.pil_elctbl_chc_popl_id = popl1.pil_elctbl_chc_popl_id
1008: and NVL(epe1.pl_id,-1) = nvl(p_pl_id, nvl(epe1.pl_id,-1))

Line 1013: from ben_pil_elctbl_chc_popl popl,

1009: and epe.fonm_cvg_strt_dt > epe1.fonm_cvg_strt_dt); /*Added not exists clause for Bug 7268357*/
1010: --
1011: cursor c_epe_pl(p_pl_id number) IS
1012: select epe.fonm_cvg_strt_dt
1013: from ben_pil_elctbl_chc_popl popl,
1014: ben_elig_per_elctbl_chc epe
1015: where popl.per_in_ler_id = p_per_in_ler_id
1016: and popl.pl_id = p_pl_id
1017: and epe.pil_elctbl_chc_popl_id = popl.pil_elctbl_chc_popl_id;

Line 2341: ben_pil_elctbl_chc_popl pel

2337: ctu.pgm_id,
2338: ctu.pl_typ_id
2339: from ben_cm_typ_usg_f ctu,
2340: ben_prtt_enrt_rslt_f pen,
2341: ben_pil_elctbl_chc_popl pel
2342: where ctu.business_group_id = p_business_group_id
2343: /* First join comp objects */
2344: and pen.business_group_id = ctu.business_group_id
2345: and pen.per_in_ler_id = p_per_in_ler_id

Line 2508: ben_pil_elctbl_chc_popl pel

2504: ctu.pgm_id,
2505: ctu.pl_typ_id
2506: from ben_cm_typ_usg_f ctu,
2507: ben_prtt_enrt_rslt_f pen,
2508: ben_pil_elctbl_chc_popl pel
2509: where ctu.business_group_id = p_business_group_id
2510: /* First join comp objects */
2511: and pen.business_group_id = ctu.business_group_id
2512: and pen.per_in_ler_id = p_per_in_ler_id

Line 3132: ben_pil_elctbl_chc_popl pel

3128: cursor c1 is
3129: select ctu.cm_typ_usg_id,
3130: ctu.cm_usg_rl
3131: from ben_cm_typ_usg_f ctu,
3132: ben_pil_elctbl_chc_popl pel
3133: where ctu.business_group_id = p_business_group_id
3134: and pel.business_group_id = ctu.business_group_id
3135: and (p_ler_id is null or
3136: nvl(ctu.ler_id,p_ler_id) = p_ler_id)