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 224: FROM ben_oipl_f o,

220: rpt.group_per_in_ler_id,
221: rpt.pl_id,
222: group_oipl.oipl_id group_oipl_id,
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,

Line 226: ben_oipl_f local_oipl,

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

Line 229: ben_oipl_f group_oipl

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

Line 622: FROM ben_oipl_f oipl

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

Line 672: ,ben_oipl_f oipl

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

Line 694: , ben_oipl_f oipl

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

Line 742: , ben_oipl_f oipl

738: , xchg.xchg_rate
739: , rt.elig_flag
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

Line 805: , ben_oipl_f oipl

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