APPS.BEN_PREM_PRTT_MONTHLY dependencies on BEN_PRTT_ENRT_RSLT_F

Line 988: from ben_prtt_enrt_rslt_f pen

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

Line 1042: from ben_prtt_enrt_rslt_f pen

1038: cursor c_old_result (p_prtt_enrt_rslt_id number,
1039: p_effective_start_date date) is
1040: select pen.effective_start_date,
1041: pen.effective_end_date, pen.prtt_enrt_rslt_id
1042: from ben_prtt_enrt_rslt_f pen
1043: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1044: and pen.prtt_enrt_rslt_stat_cd is null
1045: and pen.effective_start_date < p_effective_start_date;
1046: l_old_result c_old_result%rowtype;

Line 1077: FROM ben_prtt_enrt_rslt_f pen

1073: l_ler_typ_cd varchar2(100);
1074:
1075: cursor c_check_mo_prem(p_var VARCHAR2,l_pen_id number,p_ler_typ_cd varchar2,p_ler_id number) IS
1076: SELECT 'Y'
1077: FROM ben_prtt_enrt_rslt_f pen
1078: WHERE pen.prtt_enrt_rslt_id = l_pen_id
1079: AND pen.business_group_id = p_business_group_id
1080: AND ((p_ler_typ_cd <> 'SCHEDDO'
1081: and p_effective_date BETWEEN pen.effective_start_date