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_PER_IN_LER

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 146: FROM ben_per_in_ler pil,

142: IS
143: CURSOR c1
144: IS
145: SELECT per.full_name
146: FROM ben_per_in_ler pil,
147: per_all_people_f per
148: WHERE pil.per_in_ler_id = p_group_per_in_ler_id
149: AND pil.ws_mgr_id = per.person_id
150: AND sysdate between per.effective_start_date and per.effective_end_date;

Line 198: FROM ben_per_in_ler pil,

194: CURSOR c11
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