APPS.BEN_CWB_APPROVALS dependencies on BEN_CWB_PERSON_GROUPS

Line 47: ben_cwb_person_groups grp,

43: grp.approval_cd,
44: access_cd,
45: grp.object_version_number
46: from
47: ben_cwb_person_groups grp,
48: ben_cwb_group_hrchy hrchy,
49: ben_cwb_group_hrchy hrchy_mgr
50: where
51: hrchy.mgr_per_in_ler_id = p_group_per_in_ler_id

Line 107: BEN_CWB_PERSON_GROUPS_API.update_group_budget

103:
104:
105: if ('NA' <> l_access_cd) then
106:
107: BEN_CWB_PERSON_GROUPS_API.update_group_budget
108: (
109: p_validate => false
110: ,p_group_per_in_ler_id => l_group_per_in_ler_id
111: ,p_group_pl_id => l_group_pl_id

Line 120: BEN_CWB_PERSON_GROUPS_API.update_group_budget

116: ,p_approval_comments => ' '
117: ,p_object_version_number => l_object_version_number
118: );
119: else
120: BEN_CWB_PERSON_GROUPS_API.update_group_budget
121: (
122: p_validate => false
123: ,p_group_per_in_ler_id => l_group_per_in_ler_id
124: ,p_group_pl_id => l_group_pl_id

Line 194: from ben_cwb_person_groups

190: p_last_approver_name out nocopy varchar2) is
191:
192: cursor get_approval_status is
193: select approval_cd
194: from ben_cwb_person_groups
195: where group_per_in_ler_id= p_per_in_ler_id;
196:
197: cursor get_name(c_per_in_ler_id in number) is
198: select

Line 217: ben_cwb_person_groups

213: cursor get_next_approver is
214: select mgr_per_in_ler_id
215: from
216: ben_cwb_group_hrchy,
217: ben_cwb_person_groups
218: where
219: ben_cwb_group_hrchy.emp_per_in_ler_id = p_per_in_ler_id
220: and ben_cwb_group_hrchy.mgr_per_in_ler_id = ben_cwb_person_groups.group_per_in_ler_id
221: and group_oipl_id=-1

Line 220: and ben_cwb_group_hrchy.mgr_per_in_ler_id = ben_cwb_person_groups.group_per_in_ler_id

216: ben_cwb_group_hrchy,
217: ben_cwb_person_groups
218: where
219: ben_cwb_group_hrchy.emp_per_in_ler_id = p_per_in_ler_id
220: and ben_cwb_group_hrchy.mgr_per_in_ler_id = ben_cwb_person_groups.group_per_in_ler_id
221: and group_oipl_id=-1
222: and ((approval_cd is null ) or (approval_cd = 'RJ' ))
223: and lvl_num <> -1
224: order by lvl_num;