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 60: From ben_per_in_ler pil_emp

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

Line 62: ,ben_per_in_ler pil_mgr

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

Line 888: FROM ben_per_in_ler

884:
885: CURSOR csr_get_group_plan_info(l_group_per_in_ler_id IN NUMBER)
886: IS
887: SELECT group_pl_id, lf_evt_ocrd_dt
888: FROM ben_per_in_ler
889: WHERE per_in_ler_id = l_group_per_in_ler_id
890: AND ROWNUM < 2;
891:
892: cursor csr_is_read_only is