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

Line 121: FROM ben_per_in_ler pil, ben_cwb_pl_dsgn dsgn

117: IS
118: CURSOR c1
119: IS
120: SELECT dsgn.NAME
121: FROM ben_per_in_ler pil, ben_cwb_pl_dsgn dsgn
122: WHERE pil.per_in_ler_id = p_group_per_in_ler_id
123: AND pil.group_pl_id = dsgn.pl_id
124: AND pil.lf_evt_ocrd_dt = dsgn.lf_evt_ocrd_dt
125: AND dsgn.group_pl_id = dsgn.pl_id

Line 199: ben_cwb_pl_dsgn dsgn

195: IS
196: SELECT nvl(dsgn.wthn_yr_start_dt,dsgn.yr_perd_start_dt)||' - '||
197: nvl(dsgn.wthn_yr_end_dt,dsgn.yr_perd_end_dt) forPeriod
198: FROM ben_per_in_ler pil,
199: ben_cwb_pl_dsgn dsgn
200: WHERE pil.per_in_ler_id = p_group_per_in_ler_id
201: AND pil.group_pl_id = dsgn.group_pl_id
202: AND pil.lf_evt_ocrd_dt = dsgn.lf_evt_ocrd_dt
203: AND dsgn.oipl_id = -1