APPS.BEN_CWB_CHANGE_ACCESS dependencies on BEN_CWB_PERSON_GROUPS

Line 53: from ben_cwb_person_groups

49:
50: -- Fetch old access code, which needs to be displayed in notification
51:
52: select access_cd into l_old_access_cd
53: from ben_cwb_person_groups
54: where group_per_in_ler_id = p_group_per_in_ler_id
55: and group_pl_id = p_group_pl_id
56: and group_oipl_id = p_group_oipl_id;
57:

Line 62: BEN_CWB_PERSON_GROUPS_API.update_group_budget

58: l_requestor_first_name := substr(p_requestor_name,0, instr(p_requestor_name,' ')-1);
59: l_requestor_last_name := substr(p_requestor_name, instr(p_requestor_name,' ')+1);
60:
61: /* Update the person group information with new access code */
62: BEN_CWB_PERSON_GROUPS_API.update_group_budget
63: (p_group_per_in_ler_id => p_group_per_in_ler_id
64: ,p_group_pl_id => p_group_pl_id
65: ,p_group_oipl_id => p_group_oipl_id
66: ,p_access_cd => p_access_cd

Line 209: ben_cwb_person_groups per_grp,

205: max(per_grp.submit_cd) submit_cd
206: from
207: ben_cwb_person_info emp_per,
208: ben_cwb_group_hrchy mgr_hrchy,
209: ben_cwb_person_groups per_grp,
210: ben_cwb_summary smry
211: where
212: mgr_hrchy.mgr_per_in_ler_id in (' || l_concat_str || ')
213: and mgr_hrchy.lvl_num = 1

Line 348: ben_cwb_person_groups per_grp,

344: max(per_grp.submit_cd) submit_cd
345: from
346: ben_cwb_person_info emp_per,
347: ben_cwb_group_hrchy mgr_hrchy,
348: ben_cwb_person_groups per_grp,
349: ben_cwb_summary smry
350: where
351: mgr_hrchy.mgr_per_in_ler_id in (' || l_concat_str || ')
352: and mgr_hrchy.lvl_num > 0

Line 483: ben_cwb_person_groups per_grp,

479: max(per_grp.submit_cd) submit_cd
480: from
481: ben_cwb_person_info emp_per,
482: ben_cwb_group_hrchy mgr_hrchy,
483: ben_cwb_person_groups per_grp,
484: ben_cwb_summary smry
485: where
486: /* Looking for Direct Reports */
487: mgr_hrchy.mgr_per_in_ler_id in (' || l_concat_str || ')