eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CWB_WS_IMPORT_PKG dependencies on BEN_CWB_PL_DSGN

Line 165: ,ben_cwb_pl_dsgn dsgn

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

Line 450: ben_cwb_pl_dsgn bcpd,

446: sysdate
447: ) accesscd
448: from ben_cwb_person_info bcpi,
449: ben_cwb_person_groups bcpg,
450: ben_cwb_pl_dsgn bcpd,
451: ben_cwb_person_tasks bcpt,
452: ben_cwb_wksht_grp bcwg
453: WHERE bcpi.group_per_in_ler_id = P_MGR_PER_IN_LER_ID
454: AND bcpg.group_per_in_ler_id = bcpi.group_per_in_ler_id

Line 559: From ben_cwb_pl_dsgn dsgn

555: IS
556: Select dsgn.emp_interview_typ_cd
557: ,to_char(dsgn.perf_revw_strt_dt,'yyyy/mm/dd') perf_revw_strt_dt
558: ,dsgn.group_pl_id
559: From ben_cwb_pl_dsgn dsgn
560: ,ben_cwb_person_info inf
561: Where dsgn.group_oipl_id = -1
562: And dsgn.pl_id = inf.group_pl_id
563: And dsgn.lf_evt_ocrd_dt = inf.lf_evt_ocrd_dt

Line 683: From ben_cwb_pl_dsgn dsgn

679: IS
680: Select dsgn.EMP_INTERVIEW_TYP_CD
681: ,to_char(dsgn.asg_updt_eff_date,'yyyy/mm/dd') asg_updt_eff_date
682: ,dsgn.group_pl_id
683: From ben_cwb_pl_dsgn dsgn
684: ,ben_cwb_person_info inf
685: Where dsgn.group_oipl_id = -1
686: And dsgn.pl_id = inf.group_pl_id
687: And dsgn.lf_evt_ocrd_dt = inf.lf_evt_ocrd_dt

Line 908: ,ben_cwb_pl_dsgn dsgn

904: ,dsgn.tot_comp_rndg_cd tc_rndg_cd
905: ,dsgn.oth_comp_rndg_cd oc_rndg_cd
906: ,dsgn.stat_sal_rndg_cd ss_rndg_cd
907: From BEN_CWB_PERSON_RATES PlRt
908: ,ben_cwb_pl_dsgn dsgn
909: Where PlRt.PERSON_RATE_ID = P_PERSON_RATE_ID
910: And PlRt.ELIG_FLAG='Y'
911: and plRt.pl_id = dsgn.pl_id
912: and plRt.oipl_id = dsgn.oipl_id

Line 1355: from ben_cwb_pl_dsgn

1351: cursor csr_custom_integrator(l_group_pl_id in Number,
1352: l_lf_evt_ocrd_dt in Date) is
1353: select 'BEN_CWB_WS_INTF_' || trim(group_pl_id) intf,
1354: 'BEN_CWB_WS_LYT1_' || trim(group_pl_id) base_layout
1355: from ben_cwb_pl_dsgn
1356: where custom_integrator is not null
1357: and group_pl_id = l_group_pl_id
1358: and lf_evt_ocrd_dt = l_lf_evt_ocrd_dt;
1359: