DBA Data[Home] [Help]

APPS.BEN_CWB_WS_IMPORT_PKG dependencies on BEN_CWB_PL_DSGN

Line 164: ,ben_cwb_pl_dsgn dsgn

160: PlRt.Object_Version_Number OVN,
161: PlRt.ws_val ws_val,
162: plrt.ws_rt_start_date WS_RT_START_DATE
163: From BEN_CWB_PERSON_RATES PlRt
164: ,ben_cwb_pl_dsgn dsgn
165: Where PlRt.PERSON_RATE_ID = P_PERSON_RATE_ID
166: And PlRt.ELIG_FLAG='Y'
167: and plRt.pl_id = dsgn.pl_id
168: and plRt.oipl_id = dsgn.oipl_id

Line 478: From ben_cwb_pl_dsgn dsgn

474: IS
475: Select dsgn.EMP_INTERVIEW_TYP_CD
476: ,dsgn.perf_revw_strt_dt
477: ,dsgn.group_pl_id
478: From ben_cwb_pl_dsgn dsgn
479: ,ben_cwb_person_info inf
480: Where dsgn.group_oipl_id = -1
481: And dsgn.pl_id = inf.group_pl_id
482: And dsgn.lf_evt_ocrd_dt = inf.lf_evt_ocrd_dt