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_BACKOUT_POST_PROCESS dependencies on BEN_OPT_F

Line 82: ben_opt_f local_opt,

78: rpt.person_id
79: FROM ben_oipl_f o,
80: ben_cwb_rpt_detail rpt,
81: ben_oipl_f local_oipl,
82: ben_opt_f local_opt,
83: ben_opt_f group_opt,
84: ben_oipl_f group_oipl
85: WHERE o.pl_id = rpt.pl_id
86: AND rpt.benefit_action_id = v_benefit_action_id

Line 83: ben_opt_f group_opt,

79: FROM ben_oipl_f o,
80: ben_cwb_rpt_detail rpt,
81: ben_oipl_f local_oipl,
82: ben_opt_f local_opt,
83: ben_opt_f group_opt,
84: ben_oipl_f group_oipl
85: WHERE o.pl_id = rpt.pl_id
86: AND rpt.benefit_action_id = v_benefit_action_id
87: AND rpt.oipl_id = -1

Line 471: , ben_opt_f opt

467: CURSOR c_component_reason (v_pl_id IN NUMBER, v_effective_date IN DATE)
468: IS
469: SELECT COUNT (*)
470: FROM ben_oipl_f oipl
471: , ben_opt_f opt
472: WHERE oipl.pl_id = v_pl_id
473: AND oipl.opt_id = opt.opt_id
474: and opt.component_reason is not null
475: AND v_effective_date BETWEEN opt.effective_start_date AND opt.effective_end_date

Line 720: , ben_opt_f opt

716: , rt.comp_posting_date
717: FROM ben_cwb_person_rates rt
718: , ben_oipl_f oipl
719: , ben_cwb_pl_dsgn dsgn
720: , ben_opt_f opt
721: , ben_cwb_person_info info
722: , ben_per_in_ler pil
723: , ben_cwb_xchg xchg
724: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id

Line 784: , ben_opt_f opt

780: , ben_cwb_pl_dsgn dsgn
781: , ben_cwb_person_info info
782: , ben_per_in_ler pil
783: , ben_oipl_f oipl
784: , ben_opt_f opt
785: , ben_cwb_xchg xchg
786: WHERE rt.group_per_in_ler_id = v_group_per_in_ler_id
787: AND rt.pl_id = dsgn.pl_id
788: AND rt.oipl_id = dsgn.oipl_id

Line 796: and not exists (select null from ben_opt_f opt1 where opt.opt_id = opt1.opt_id and opt1.component_reason is not null) --12616726

792: AND rt.group_per_in_ler_id = pil.per_in_ler_id
793: AND rt.oipl_id = oipl.oipl_id (+)
794: AND oipl.opt_id = opt.opt_id (+)
795: -- AND opt.component_reason(+) is null --12571024
796: and not exists (select null from ben_opt_f opt1 where opt.opt_id = opt1.opt_id and opt1.component_reason is not null) --12616726
797: AND v_effective_date BETWEEN opt.effective_start_date (+) AND opt.effective_end_date (+)
798: AND v_effective_date BETWEEN oipl.effective_start_date (+)AND oipl.effective_end_date (+)
799: and xchg.group_pl_id = rt.group_pl_id
800: and xchg.lf_evt_ocrd_dt = rt.lf_evt_ocrd_dt