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_PERSON_RATES

Line 43: from ben_cwb_person_rates rt

39: ,rt.misc2_val/decode(pl.misc2_nnmntry_uom,null
40: ,xchg.xchg_rate,1) misc2_val
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

Line 1313: ,ben_cwb_person_rates rt

1309: ,xchg.xchg_rate,1)) misc2_val_direct
1310: ,sum(rt.misc3_val/decode(pl.misc3_nnmntry_uom,null
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

Line 1894: ,ben_cwb_person_rates rt

1890: ,xchg.xchg_rate,1)) misc2_val
1891: ,sum(rt.misc3_val/decode(pl.misc3_nnmntry_uom,null
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