[Home] [Help]
234: rpt.person_id
235: FROM ben_oipl_f o,
236: ben_cwb_rpt_detail rpt,
237: ben_oipl_f local_oipl,
238: ben_opt_f local_opt,
239: ben_opt_f group_opt,
240: ben_oipl_f group_oipl
241: WHERE o.pl_id = rpt.pl_id
242: AND rpt.benefit_action_id = v_benefit_action_id
235: FROM ben_oipl_f o,
236: ben_cwb_rpt_detail rpt,
237: ben_oipl_f local_oipl,
238: ben_opt_f local_opt,
239: ben_opt_f group_opt,
240: ben_oipl_f group_oipl
241: WHERE o.pl_id = rpt.pl_id
242: AND rpt.benefit_action_id = v_benefit_action_id
243: AND rpt.oipl_id = -1
630: CURSOR c_component_reason (v_pl_id IN NUMBER, v_effective_date IN DATE)
631: IS
632: SELECT COUNT (*)
633: FROM ben_oipl_f oipl
634: , ben_opt_f opt
635: WHERE oipl.pl_id = v_pl_id
636: AND oipl.opt_id = opt.opt_id
637: and opt.component_reason is not null
638: AND v_effective_date BETWEEN opt.effective_start_date AND opt.effective_end_date
681: IS
682: SELECT SUM (rt.ws_val)
683: FROM ben_cwb_person_rates rt
684: ,ben_oipl_f oipl
685: ,ben_opt_f opt
686: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
687: AND rt.group_pl_id = v_group_pl_id
688: AND rt.oipl_id <> -1
689: AND rt.lf_evt_ocrd_dt = v_lf_evt_orcd_dt
704: min(OVRID_RT_STRT_DT)) effective_date
705: FROM ben_cwb_person_rates rt
706: , ben_oipl_f oipl
707: , ben_cwb_pl_dsgn dsgn
708: , ben_opt_f opt
709: , ben_cwb_person_info info
710: , ben_per_in_ler pil
711: , ben_cwb_xchg xchg
712: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
752: , rt.currency
753: FROM ben_cwb_person_rates rt
754: , ben_oipl_f oipl
755: , ben_cwb_pl_dsgn dsgn
756: , ben_opt_f opt
757: , ben_cwb_person_info info
758: , ben_per_in_ler pil
759: , ben_cwb_xchg xchg
760: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
814: , ben_cwb_pl_dsgn dsgn
815: , ben_cwb_person_info info
816: , ben_per_in_ler pil
817: , ben_oipl_f oipl
818: , ben_opt_f opt
819: , ben_cwb_xchg xchg
820: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
821: AND rt.pl_id = dsgn.pl_id
822: AND rt.oipl_id = dsgn.oipl_id