DBA Data[Home] [Help]

APPS.BEN_CWB_DYN_CALC_PKG dependencies on BEN_CWB_ASG_UPDATE

Line 203: ,ben_cwb_asg_update.g_ws_perf_rec_type||

199: select o1.oipl_id oipl_id1
200: ,o2.oipl_id oipl_id2
201: ,o3.oipl_id oipl_id3
202: ,o4.oipl_id oipl_id4
203: ,ben_cwb_asg_update.g_ws_perf_rec_type||
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

Line 206: ,ben_cwb_asg_update.g_ws_asg_rec_type||

202: ,o4.oipl_id oipl_id4
203: ,ben_cwb_asg_update.g_ws_perf_rec_type||
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