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_DATA_MODEL_UPGRADE dependencies on BEN_CWB_PL_DSGN

Line 124: from ben_cwb_pl_dsgn pln

120: and cyc.popl_enrt_typ_cycl_id = enp.popl_enrt_typ_cycl_id
121: -- and pl.group_pl_id is null
122: and enp.data_freeze_date is null
123: and not exists (select 'Y'
124: from ben_cwb_pl_dsgn pln
125: where pln.pl_id = pl.pl_id
126: and pln.lf_evt_ocrd_dt = enp.asnd_lf_evt_dt)
127: and exists (select 'Y'
128: from ben_per_in_ler pil

Line 297: ben_cwb_pl_dsgn_pkg.refresh_pl_dsgn(l_pl_dsgn.pl_id,l_pl_dsgn.asnd_lf_evt_dt,l_pl_dsgn.asnd_lf_evt_dt);

293: null;
294: end;
295:
296: -- Refresh Plan design information
297: ben_cwb_pl_dsgn_pkg.refresh_pl_dsgn(l_pl_dsgn.pl_id,l_pl_dsgn.asnd_lf_evt_dt,l_pl_dsgn.asnd_lf_evt_dt);
298:
299: l_old_pl_id := l_pl_dsgn.pl_id;
300: l_old_pl_typ_id := l_pl_dsgn.pl_typ_id;
301:

Line 1241: from ben_cwb_pl_dsgn pldsgn

1237:
1238:
1239: select emp_interview_typ_cd
1240: into l_performance_rating_type
1241: from ben_cwb_pl_dsgn pldsgn
1242: where pldsgn.pl_id = p_group_pl_id
1243: and pldsgn.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
1244: and pldsgn.oipl_id = -1 ;
1245:

Line 1430: from ben_cwb_pl_dsgn pl

1426:
1427: cursor c_plans is
1428: select distinct pl.group_pl_id
1429: ,pl.lf_evt_ocrd_dt
1430: from ben_cwb_pl_dsgn pl
1431: where pl.pl_id = pl.group_pl_id
1432: and not exists (select 'Y'
1433: from ben_cwb_summary summ
1434: where summ.group_pl_id = pl.group_pl_id