APPS.BEN_EXT_CWB dependencies on BEN_CWB_PL_DSGN

Line 142: ben_cwb_pl_dsgn pl

138: cwg.WS_BDGT_MX_VAL,
139: cwg.WS_BDGT_VAL_LAST_UPD_DATE ,
140: cwg.WS_BDGT_VAL_LAST_UPD_BY
141: from BEN_CWB_PERSON_GROUPS cwg ,
142: ben_cwb_pl_dsgn pl
143: -- ben_cwb_pl_dsgn oipl
144: where GROUP_PER_IN_LER_ID = p_per_in_ler_id
145: and pl.pl_id = cwg.GROUP_PL_ID
146: and pl.oipl_id = -1 --- for the plan record oipl is -1

Line 143: -- ben_cwb_pl_dsgn oipl

139: cwg.WS_BDGT_VAL_LAST_UPD_DATE ,
140: cwg.WS_BDGT_VAL_LAST_UPD_BY
141: from BEN_CWB_PERSON_GROUPS cwg ,
142: ben_cwb_pl_dsgn pl
143: -- ben_cwb_pl_dsgn oipl
144: where GROUP_PER_IN_LER_ID = p_per_in_ler_id
145: and pl.pl_id = cwg.GROUP_PL_ID
146: and pl.oipl_id = -1 --- for the plan record oipl is -1
147: and cwg.lf_evt_ocrd_dt = pl.lf_evt_ocrd_dt

Line 159: from ben_cwb_pl_dsgn

155: cursor c_name (l_pl_id number ,
156: l_oipl_id number ,
157: l_date date ) is
158: select name
159: from ben_cwb_pl_dsgn
160: where pl_id = l_pl_id
161: and oipl_id = l_oipl_id
162: and lf_evt_ocrd_dt = l_date
163: ;

Line 272: ben_cwb_pl_dsgn pl1 ,

268: cpr.WS_VAL ,
269: cpr.lf_evt_ocrd_dt
270: From
271: ben_cwb_person_rates cpr ,
272: ben_cwb_pl_dsgn pl1 ,
273: ben_cwb_pl_dsgn pl2
274: where
275: cpr.group_per_in_ler_id = p_per_in_ler_id
276: and cpr.group_pl_id = pl1.pl_id

Line 273: ben_cwb_pl_dsgn pl2

269: cpr.lf_evt_ocrd_dt
270: From
271: ben_cwb_person_rates cpr ,
272: ben_cwb_pl_dsgn pl1 ,
273: ben_cwb_pl_dsgn pl2
274: where
275: cpr.group_per_in_ler_id = p_per_in_ler_id
276: and cpr.group_pl_id = pl1.pl_id
277: and pl1.oipl_id = -1

Line 288: from ben_cwb_pl_dsgn oipl

284: cursor c_oipl (p_oipl_id number,
285: p_pl_id number,
286: p_lf_evt_ocrd_dt date) is
287: select oipl.name
288: from ben_cwb_pl_dsgn oipl
289: where oipl.oipl_id = p_oipl_id
290: and oipl.pl_id = p_pl_id
291: and p_lf_evt_ocrd_dt = oipl.lf_evt_ocrd_dt
292: ;