APPS.BEN_CWB_WS_IMPORT_PKG dependencies on BEN_CWB_GROUP_HRCHY

Line 62: ,ben_cwb_group_hrchy mgr

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
66: and mgr.lvl_num > 0

Line 408: ben_cwb_group_hrchy hrchy

404: CURSOR csr_ws_stat_cd (p_mgr_ler_id IN NUMBER) IS
405: /* Changed cursor for bug#9692823
406: SELECT submit_cd
407: FROM ben_cwb_person_groups mgr,
408: ben_cwb_group_hrchy hrchy
409: WHERE hrchy.emp_per_in_ler_id = l_ler_id
410: and hrchy.mgr_per_in_ler_id = mgr.group_per_in_ler_id
411: and hrchy.lvl_num = 1*/
412: SELECT 'SU'

Line 413: FROM ben_cwb_group_hrchy h

409: WHERE hrchy.emp_per_in_ler_id = l_ler_id
410: and hrchy.mgr_per_in_ler_id = mgr.group_per_in_ler_id
411: and hrchy.lvl_num = 1*/
412: SELECT 'SU'
413: FROM ben_cwb_group_hrchy h
414: WHERE emp_per_in_ler_id = p_mgr_ler_id
415: AND EXISTS (SELECT 'x'
416: FROM ben_cwb_person_groups
417: WHERE group_per_in_ler_id = h.mgr_per_in_ler_id

Line 426: FROM BEN_CWB_GROUP_HRCHY

422: CURSOR csr_chk_hrchy(p_mgr_ler_id NUMBER,p_emp_ler_id NUMBER) IS -- bug: 8996634
423: SELECT 'Y'
424: FROM DUAL
425: WHERE EXISTS (SELECT 'X'
426: FROM BEN_CWB_GROUP_HRCHY
427: WHERE MGR_PER_IN_LER_ID = p_mgr_ler_id
428: AND EMP_PER_IN_LER_ID = p_emp_ler_id );
429: l_chk_hrchy VARCHAR2(10);
430: