eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CWB_POST_PROCESS dependencies on BEN_OIPL_F

Line 235: FROM ben_oipl_f o,

231: rpt.group_per_in_ler_id,
232: rpt.pl_id,
233: group_oipl.oipl_id group_oipl_id,
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,

Line 237: ben_oipl_f local_oipl,

233: group_oipl.oipl_id group_oipl_id,
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

Line 240: ben_oipl_f group_oipl

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
244: AND local_oipl.oipl_id = o.oipl_id

Line 633: FROM ben_oipl_f oipl

629:
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

Line 684: ,ben_oipl_f oipl

680: )
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

Line 706: , ben_oipl_f oipl

702: SELECT DECODE(v_rule_based,'Y',
703: min(WS_RT_START_DATE),
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

Line 754: , ben_oipl_f oipl

750: , xchg.xchg_rate
751: , rt.elig_flag
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

Line 817: , ben_oipl_f oipl

813: FROM ben_cwb_person_rates rt
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