APPS.BEN_CWB_WS_IMPORT_PKG dependencies on BEN_CWB_PERSON_GROUPS

Line 403: FROM ben_cwb_person_groups mgr,

399:
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;

Line 408: l_submit_cd ben_cwb_person_groups.submit_cd%TYPE;

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;
409:
410: BEGIN
411: hr_utility.set_location('Entering :'||l_proc,10);
412: