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_SUMMARY_PKG dependencies on BEN_CWB_XCHG

Line 45: ,ben_cwb_xchg xchg

41: ,rt.misc3_val/decode(pl.misc3_nnmntry_uom,null
42: ,xchg.xchg_rate,1) misc3_val
43: from ben_cwb_person_rates rt
44: ,ben_cwb_pl_dsgn pl
45: ,ben_cwb_xchg xchg
46: where rt.group_per_in_ler_id = v_per_in_ler_id
47: and rt.pl_id = pl.pl_id
48: and rt.oipl_id = pl.oipl_id
49: and rt.lf_evt_ocrd_dt = pl.lf_evt_ocrd_dt

Line 1315: ,ben_cwb_xchg xchg

1311: ,xchg.xchg_rate,1)) misc3_val_direct
1312: from ben_cwb_group_hrchy hrchy
1313: ,ben_cwb_person_rates rt
1314: ,ben_cwb_pl_dsgn pl
1315: ,ben_cwb_xchg xchg
1316: where rt.group_pl_id = p_group_pl_id
1317: and rt.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
1318: and rt.elig_flag = 'Y'
1319: and rt.group_per_in_ler_id = hrchy.emp_per_in_ler_id

Line 1896: ,ben_cwb_xchg xchg

1892: ,xchg.xchg_rate,1)) misc3_val
1893: from ben_cwb_group_hrchy hrchy
1894: ,ben_cwb_person_rates rt
1895: ,ben_cwb_pl_dsgn pl
1896: ,ben_cwb_xchg xchg
1897: where hrchy.mgr_per_in_ler_id = v_group_per_in_ler_id
1898: and rt.group_per_in_ler_id = hrchy.emp_per_in_ler_id
1899: and hrchy.lvl_num = 1
1900: and rt.elig_flag = 'Y'