APPS.BEN_PREM_PRTT_MONTHLY dependencies on BEN_PRTT_ENRT_RSLT_F

Line 982: from ben_prtt_enrt_rslt_f pen

978: cursor c_results is
979: select pen.person_id, pen.pl_id, pen.oipl_id, pen.effective_start_date,
980: pen.effective_end_date, pen.enrt_cvg_strt_dt, pen.enrt_cvg_thru_dt,
981: pen.pgm_id, pen.pl_typ_id, pen.ler_id, pen.prtt_enrt_rslt_id
982: from ben_prtt_enrt_rslt_f pen
983: where pen.prtt_enrt_rslt_stat_cd is null
984: and pen.sspndd_flag = 'N'
985: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP') -- not a dummy plan
986: -- cvg starts sometime before end of next month

Line 1029: from ben_prtt_enrt_rslt_f pen

1025: cursor c_old_result (p_prtt_enrt_rslt_id number,
1026: p_effective_start_date date) is
1027: select pen.effective_start_date,
1028: pen.effective_end_date, pen.prtt_enrt_rslt_id
1029: from ben_prtt_enrt_rslt_f pen
1030: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1031: and pen.prtt_enrt_rslt_stat_cd is null
1032: and pen.effective_start_date < p_effective_start_date;
1033: l_old_result c_old_result%rowtype;

Line 1064: FROM ben_prtt_enrt_rslt_f pen

1060: l_ler_typ_cd varchar2(100);
1061:
1062: cursor c_check_mo_prem(p_var VARCHAR2,l_pen_id number,p_ler_typ_cd varchar2,p_ler_id number) IS
1063: SELECT 'Y'
1064: FROM ben_prtt_enrt_rslt_f pen
1065: WHERE pen.prtt_enrt_rslt_id = l_pen_id
1066: AND pen.business_group_id = p_business_group_id
1067: AND ((p_ler_typ_cd <> 'SCHEDDO'
1068: and p_effective_date BETWEEN pen.effective_start_date