[Home] [Help]
223: rpt.person_id
224: FROM ben_oipl_f o,
225: ben_cwb_rpt_detail rpt,
226: ben_oipl_f local_oipl,
227: ben_opt_f local_opt,
228: ben_opt_f group_opt,
229: ben_oipl_f group_oipl
230: WHERE o.pl_id = rpt.pl_id
231: AND rpt.benefit_action_id = v_benefit_action_id
224: FROM ben_oipl_f o,
225: ben_cwb_rpt_detail rpt,
226: ben_oipl_f local_oipl,
227: ben_opt_f local_opt,
228: ben_opt_f group_opt,
229: ben_oipl_f group_oipl
230: WHERE o.pl_id = rpt.pl_id
231: AND rpt.benefit_action_id = v_benefit_action_id
232: AND rpt.oipl_id = -1
619: CURSOR c_component_reason (v_pl_id IN NUMBER, v_effective_date IN DATE)
620: IS
621: SELECT COUNT (*)
622: FROM ben_oipl_f oipl
623: , ben_opt_f opt
624: WHERE oipl.pl_id = v_pl_id
625: AND oipl.opt_id = opt.opt_id
626: and opt.component_reason is not null
627: AND v_effective_date BETWEEN opt.effective_start_date AND opt.effective_end_date
669: IS
670: SELECT SUM (rt.ws_val)
671: FROM ben_cwb_person_rates rt
672: ,ben_oipl_f oipl
673: ,ben_opt_f opt
674: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
675: AND rt.group_pl_id = v_group_pl_id
676: AND rt.oipl_id <> -1
677: AND rt.lf_evt_ocrd_dt = v_lf_evt_orcd_dt
692: min(OVRID_RT_STRT_DT)) effective_date
693: FROM ben_cwb_person_rates rt
694: , ben_oipl_f oipl
695: , ben_cwb_pl_dsgn dsgn
696: , ben_opt_f opt
697: , ben_cwb_person_info info
698: , ben_per_in_ler pil
699: , ben_cwb_xchg xchg
700: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
740: , rt.currency
741: FROM ben_cwb_person_rates rt
742: , ben_oipl_f oipl
743: , ben_cwb_pl_dsgn dsgn
744: , ben_opt_f opt
745: , ben_cwb_person_info info
746: , ben_per_in_ler pil
747: , ben_cwb_xchg xchg
748: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
802: , ben_cwb_pl_dsgn dsgn
803: , ben_cwb_person_info info
804: , ben_per_in_ler pil
805: , ben_oipl_f oipl
806: , ben_opt_f opt
807: , ben_cwb_xchg xchg
808: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
809: AND rt.pl_id = dsgn.pl_id
810: AND rt.oipl_id = dsgn.oipl_id