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 912: from ben_prtt_rt_val prv,

908: prv.ann_rt_val,
909: prv.cmcd_rt_val, -- Bug 6015724
910: prv.rt_strt_dt,
911: prv.rt_end_dt
912: from ben_prtt_rt_val prv,
913: ben_prtt_enrt_rslt_f pen,
914: ben_elig_per_elctbl_chc epe
915: where epe.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
916: and epe.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id

Line 947: from ben_prtt_rt_val prv,

943: prv.ann_rt_val,
944: prv.cmcd_rt_val, -- Bug 6015724
945: prv.rt_strt_dt,
946: prv.rt_end_dt
947: from ben_prtt_rt_val prv,
948: ben_prtt_enrt_rslt_f pen
949: where pen.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
950: and pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
951: and pen.prtt_enrt_rslt_stat_cd is null

Line 984: from ben_prtt_rt_val prv,

980: prv.ann_rt_val,
981: prv.cmcd_rt_val, -- Bug 6015724
982: prv.rt_strt_dt,
983: prv.rt_end_dt
984: from ben_prtt_rt_val prv,
985: ben_prtt_enrt_rslt_f pen
986: where pen.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
987: and pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
988: and pen.prtt_enrt_rslt_stat_cd is null

Line 1189: FROM ben_prtt_rt_val prv

1185: AND yp.business_group_id = p_business_group_id;
1186: --
1187: cursor c_min_rt_strt_dt(p_business_group_id number) is
1188: SELECT min(prv.rt_strt_dt)
1189: FROM ben_prtt_rt_val prv
1190: where prv.acty_base_rt_id = p_acty_base_rt_id
1191: and prv.prtt_rt_val_stat_cd is null
1192: and prv.business_group_id = p_business_group_id
1193: and prv.prtt_enrt_rslt_id in