DBA Data[Home] [Help]

APPS.BEN_CWB_WS_IMPORT_PKG dependencies on BEN_CWB_GROUP_HRCHY

Line 61: ,ben_cwb_group_hrchy mgr

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

Line 404: ben_cwb_group_hrchy hrchy

400: -- added by kmg for fixing bug#6830922
401: CURSOR csr_ws_stat_cd (l_ler_id IN NUMBER) IS
402: SELECT submit_cd
403: FROM ben_cwb_person_groups mgr,
404: ben_cwb_group_hrchy hrchy
405: WHERE hrchy.emp_per_in_ler_id = l_ler_id
406: and hrchy.mgr_per_in_ler_id = mgr.group_per_in_ler_id
407: and hrchy.lvl_num = 1;
408: l_submit_cd ben_cwb_person_groups.submit_cd%TYPE;