APPS.BEN_CWB_WS_IMPORT_PKG dependencies on BEN_CWB_PERSON_GROUPS

Line 407: FROM ben_cwb_person_groups mgr,

403: -- added by kmg for fixing bug#6830922
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*/

Line 416: FROM ben_cwb_person_groups

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
418: AND SUBMIT_CD = 'SU')
419: ;
420: l_submit_cd ben_cwb_person_groups.submit_cd%TYPE;

Line 420: l_submit_cd ben_cwb_person_groups.submit_cd%TYPE;

416: FROM ben_cwb_person_groups
417: WHERE group_per_in_ler_id = h.mgr_per_in_ler_id
418: AND SUBMIT_CD = 'SU')
419: ;
420: l_submit_cd ben_cwb_person_groups.submit_cd%TYPE;
421:
422: CURSOR csr_chk_hrchy(p_mgr_ler_id NUMBER,p_emp_ler_id NUMBER) IS -- bug: 8996634
423: SELECT 'Y'
424: FROM DUAL

Line 449: ben_cwb_person_groups bcpg,

445: ),
446: sysdate
447: ) accesscd
448: from ben_cwb_person_info bcpi,
449: ben_cwb_person_groups bcpg,
450: ben_cwb_pl_dsgn bcpd,
451: ben_cwb_person_tasks bcpt,
452: ben_cwb_wksht_grp bcwg
453: WHERE bcpi.group_per_in_ler_id = P_MGR_PER_IN_LER_ID