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_WS_IMPORT_PKG dependencies on BEN_PER_IN_LER

Line 61: From ben_per_in_ler pil_emp

57:
58: Cursor Csr_Assignment_ID IS
59: Select pil_emp.assignment_id
60: ,mgr.lvl_num
61: From ben_per_in_ler pil_emp
62: ,ben_cwb_group_hrchy mgr
63: ,ben_per_in_ler pil_mgr
64: Where pil_emp.per_in_ler_id = p_group_per_in_ler_id
65: and pil_emp.per_in_ler_id = mgr.emp_per_in_ler_id

Line 63: ,ben_per_in_ler pil_mgr

59: Select pil_emp.assignment_id
60: ,mgr.lvl_num
61: From ben_per_in_ler pil_emp
62: ,ben_cwb_group_hrchy mgr
63: ,ben_per_in_ler pil_mgr
64: Where pil_emp.per_in_ler_id = p_group_per_in_ler_id
65: and pil_emp.per_in_ler_id = mgr.emp_per_in_ler_id
66: and mgr.lvl_num > 0
67: and mgr.mgr_per_in_ler_id = pil_mgr.per_in_ler_id

Line 1347: FROM ben_per_in_ler

1343:
1344: CURSOR csr_get_group_plan_info(l_group_per_in_ler_id IN NUMBER)
1345: IS
1346: SELECT group_pl_id, lf_evt_ocrd_dt
1347: FROM ben_per_in_ler
1348: WHERE per_in_ler_id = l_group_per_in_ler_id
1349: AND ROWNUM < 2;
1350:
1351: cursor csr_custom_integrator(l_group_pl_id in Number,