APPS.BEN_CWB_DYN_CALC_PKG dependencies on BEN_CWB_PL_DSGN

Line 162: ,ben_cwb_pl_dsgn dsgn

158: ,null new_grd_comparatio
159: ,null new_grd_quartile
160: from ben_cwb_person_info inf
161: ,ben_cwb_person_rates pl
162: ,ben_cwb_pl_dsgn dsgn
163: ,ben_transaction perf
164: ,ben_transaction asg
165: ,ben_cwb_person_rates opt1
166: ,ben_cwb_person_rates opt2

Line 208: from ben_cwb_pl_dsgn pl

204: to_char(pl.perf_revw_strt_dt,'yyyy/mm/dd')||
205: pl.emp_interview_typ_cd perf_txn_type
206: ,ben_cwb_asg_update.g_ws_asg_rec_type||
207: to_char(pl.asg_updt_eff_date,'yyyy/mm/dd') asg_txn_type
208: from ben_cwb_pl_dsgn pl
209: ,ben_cwb_pl_dsgn o1
210: ,ben_cwb_pl_dsgn o2
211: ,ben_cwb_pl_dsgn o3
212: ,ben_cwb_pl_dsgn o4

Line 209: ,ben_cwb_pl_dsgn o1

205: pl.emp_interview_typ_cd perf_txn_type
206: ,ben_cwb_asg_update.g_ws_asg_rec_type||
207: to_char(pl.asg_updt_eff_date,'yyyy/mm/dd') asg_txn_type
208: from ben_cwb_pl_dsgn pl
209: ,ben_cwb_pl_dsgn o1
210: ,ben_cwb_pl_dsgn o2
211: ,ben_cwb_pl_dsgn o3
212: ,ben_cwb_pl_dsgn o4
213: where pl.pl_id = v_group_pl_id

Line 210: ,ben_cwb_pl_dsgn o2

206: ,ben_cwb_asg_update.g_ws_asg_rec_type||
207: to_char(pl.asg_updt_eff_date,'yyyy/mm/dd') asg_txn_type
208: from ben_cwb_pl_dsgn pl
209: ,ben_cwb_pl_dsgn o1
210: ,ben_cwb_pl_dsgn o2
211: ,ben_cwb_pl_dsgn o3
212: ,ben_cwb_pl_dsgn o4
213: where pl.pl_id = v_group_pl_id
214: and pl.lf_evt_ocrd_dt = v_lf_evt_ocrd_dt

Line 211: ,ben_cwb_pl_dsgn o3

207: to_char(pl.asg_updt_eff_date,'yyyy/mm/dd') asg_txn_type
208: from ben_cwb_pl_dsgn pl
209: ,ben_cwb_pl_dsgn o1
210: ,ben_cwb_pl_dsgn o2
211: ,ben_cwb_pl_dsgn o3
212: ,ben_cwb_pl_dsgn o4
213: where pl.pl_id = v_group_pl_id
214: and pl.lf_evt_ocrd_dt = v_lf_evt_ocrd_dt
215: and pl.oipl_id = -1

Line 212: ,ben_cwb_pl_dsgn o4

208: from ben_cwb_pl_dsgn pl
209: ,ben_cwb_pl_dsgn o1
210: ,ben_cwb_pl_dsgn o2
211: ,ben_cwb_pl_dsgn o3
212: ,ben_cwb_pl_dsgn o4
213: where pl.pl_id = v_group_pl_id
214: and pl.lf_evt_ocrd_dt = v_lf_evt_ocrd_dt
215: and pl.oipl_id = -1
216: and pl.pl_id = o1.pl_id (+)

Line 410: from ben_cwb_pl_dsgn

406: function get_new_salary return number is
407: cursor c_local_plan_info is
408: select oipl_id,
409: oipl_ordr_num
410: from ben_cwb_pl_dsgn
411: where pl_id = g_allocation_row.pl_id
412: and lf_evt_ocrd_dt = g_allocation_row.lf_evt_ocrd_dt
413: and group_pl_id = g_allocation_row.group_pl_id
414: and ws_sub_acty_typ_cd = 'ICM7';