APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_ELIG_PER_F

Line 856: from ben_elig_per_f pep

852: --
853: cursor c_pep IS
854: select pgm_id,
855: pl_id
856: from ben_elig_per_f pep
857: where pep.per_in_ler_id = p_per_in_ler_id
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

Line 938: ben_elig_per_f pep,

934: ctu.pgm_id,
935: ctu.ler_id,
936: ctu.pl_typ_id
937: from ben_cm_typ_usg_f ctu,
938: ben_elig_per_f pep,
939: ben_per_in_ler pil
940: where ctu.business_group_id = p_business_group_id
941: and pep.business_group_id = ctu.business_group_id
942: and pep.person_id = p_person_id

Line 997: FROM ben_elig_per_f pep2, ben_per_in_ler pil2

993: and nvl(pil.per_in_ler_stat_cd,'-1') not in ('VOIDD','BCKDT')
994: ---look for previous eligble
995: and (( p_eligible_flag = 'Y'
996: and not exists ( SELECT 'x'
997: FROM ben_elig_per_f pep2, ben_per_in_ler pil2
998: WHERE pep2.person_id = pep.person_id
999: AND (ctu.pl_id is null or nvl(pep2.pl_id,-1) = nvl(pep.pl_id,-1) )
1000: AND (ctu.pgm_id is null or nvl(pep2.pgm_id,-1) = nvl(pep.pgm_id,-1) )
1001: --- pep ler id is not updated so pil ler id is validated # 2784972

Line 1028: FROM ben_elig_per_f pep2, ben_per_in_ler pil2

1024: )
1025: OR
1026: ( p_eligible_flag = 'N'
1027: and exists ( SELECT 'x'
1028: FROM ben_elig_per_f pep2, ben_per_in_ler pil2
1029: WHERE pep2.person_id = pep.person_id
1030: AND (ctu.pl_id is null or nvl(pep2.pl_id,-1) = nvl(pep.pl_id,-1) )
1031: AND (ctu.pgm_id is null or nvl(pep2.pgm_id,-1) = nvl(pep.pgm_id,-1) )
1032: -- pep ler id is not updated so pil led id is used # 2784972

Line 1061: from ben_elig_per_f pep,

1057:
1058: --
1059: cursor c2(cv_effective_date date, cv_lf_evt_ocrd_dt date) is
1060: select null
1061: from ben_elig_per_f pep,
1062: ben_per_in_ler pil
1063: where pep.business_group_id = p_business_group_id
1064: and pep.person_id = p_person_id
1065: and nvl(get_cvg_strt_dt(pep.elig_per_id,pil.per_in_ler_id),cv_effective_date)

Line 1096: FROM ben_elig_per_f pep,

1092: c_ler_id number,
1093: c_pl_typ_id number,
1094: cv_effective_date date) is
1095: select 'x'
1096: FROM ben_elig_per_f pep,
1097: ben_per_in_ler pil,
1098: ben_elig_dpnt egd
1099: WHERE egd.dpnt_person_id = p_person_id
1100: and egd.business_group_id = p_business_group_id