APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on BEN_PRTT_RT_VAL

Line 48: 27 Oct 98 T Guy 115.4 removed date track for ben_prtt_rt_val_f

44: Added call to calculate rt_strt_dt and
45: get rt_strt_dt_cd and rl.
46: ben_determine_date.rate_and_coverage_dates
47: 25 Oct 98 T Guy 115.3 removed show errors
48: 27 Oct 98 T Guy 115.4 removed date track for ben_prtt_rt_val_f
49: 29 Oct 98 T Guy 115.5 fixed dflt_ann val
50: 12 Nov 98 T Guy 115.6 Implemented overall min/max val and
51: rules
52: 24 Nov 98 T Guy 115.7 Fixed undefined upr/lwr rule checking

Line 895: from ben_prtt_rt_val prv,

891: prv.ann_rt_val,
892: prv.cmcd_rt_val, -- Bug 6015724
893: prv.rt_strt_dt,
894: prv.rt_end_dt
895: from ben_prtt_rt_val prv,
896: ben_prtt_enrt_rslt_f pen,
897: ben_elig_per_elctbl_chc epe
898: where epe.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
899: and epe.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id

Line 930: from ben_prtt_rt_val prv,

926: prv.ann_rt_val,
927: prv.cmcd_rt_val, -- Bug 6015724
928: prv.rt_strt_dt,
929: prv.rt_end_dt
930: from ben_prtt_rt_val prv,
931: ben_prtt_enrt_rslt_f pen
932: where pen.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
933: and pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
934: and pen.prtt_enrt_rslt_stat_cd is null

Line 967: from ben_prtt_rt_val prv,

963: prv.ann_rt_val,
964: prv.cmcd_rt_val, -- Bug 6015724
965: prv.rt_strt_dt,
966: prv.rt_end_dt
967: from ben_prtt_rt_val prv,
968: ben_prtt_enrt_rslt_f pen
969: where pen.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
970: and pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
971: and pen.prtt_enrt_rslt_stat_cd is null