APPS.BEN_CWB_BACKOUT_POST_PROCESS dependencies on BEN_OIPL_F

Line 79: FROM ben_oipl_f o,

75: rpt.group_per_in_ler_id,
76: rpt.pl_id,
77: group_oipl.oipl_id group_oipl_id,
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,

Line 81: ben_oipl_f local_oipl,

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

Line 84: ben_oipl_f group_oipl

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

Line 470: FROM ben_oipl_f oipl

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

Line 718: , ben_oipl_f oipl

714: , rt.elig_flag
715: , rt.currency
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

Line 783: , ben_oipl_f oipl

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