APPS.BEN_CWB_BACK_OUT_CONC dependencies on BEN_CWB_GROUP_HRCHY

Line 126: from ben_cwb_group_hrchy

122: (p_per_in_ler_id in number
123: ) is
124: cursor c_chr is
125: select rowid
126: from ben_cwb_group_hrchy
127: where mgr_per_in_ler_id = p_per_in_ler_id;
128: --
129: l_proc varchar2(50) := g_package||'.cwb_delete_routine';
130: begin

Line 136: delete from ben_cwb_group_hrchy hrc

132: hr_utility.set_location( 'Entering '|| l_proc, 5);
133: --
134: -- Delete heirarchy data : bug 4021004
135: --
136: delete from ben_cwb_group_hrchy hrc
137: where emp_per_in_ler_id = p_per_in_ler_id;
138: --
139: -- Now delete all the data where this per in ler id is manager
140: --

Line 143: update ben_cwb_group_hrchy set

139: -- Now delete all the data where this per in ler id is manager
140: --
141: for l_chr in c_chr loop
142: begin
143: update ben_cwb_group_hrchy set
144: mgr_per_in_ler_id = -1 ,
145: LVL_NUM = -1
146: where rowid = l_chr.rowid;
147: exception

Line 164: from ben_cwb_group_hrchy

160: (p_per_in_ler_id in number
161: ) is
162: cursor c_chr is
163: select rowid, emp_per_in_ler_id
164: from ben_cwb_group_hrchy
165: where mgr_per_in_ler_id = p_per_in_ler_id;
166: --
167: l_proc varchar2(50) := g_package||'.cwb_delete_routine';
168: begin

Line 174: delete from ben_cwb_group_hrchy hrc

170: hr_utility.set_location( 'Entering '|| l_proc, 5);
171: --
172: -- Delete heirarchy data : bug 4021004
173: --
174: delete from ben_cwb_group_hrchy hrc
175: where emp_per_in_ler_id = p_per_in_ler_id;
176: --
177: -- Now delete all the data where this per in ler id is manager
178: --

Line 181: update ben_cwb_group_hrchy set

177: -- Now delete all the data where this per in ler id is manager
178: --
179: for l_chr in c_chr loop
180: begin
181: update ben_cwb_group_hrchy set
182: mgr_per_in_ler_id = -1 ,
183: LVL_NUM = -1
184: where rowid = l_chr.rowid;
185: --

Line 186: delete from ben_cwb_group_hrchy

182: mgr_per_in_ler_id = -1 ,
183: LVL_NUM = -1
184: where rowid = l_chr.rowid;
185: --
186: delete from ben_cwb_group_hrchy
187: where emp_per_in_ler_id = l_chr.emp_per_in_ler_id
188: and LVL_NUM > -1;
189: --
190: exception

Line 1279: from ben_cwb_group_hrchy hrchy

1275: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')
1276: and pil.ws_mgr_id is not null
1277: and pil.per_in_ler_id = inf.group_per_in_ler_id
1278: and not exists (select 'Y'
1279: from ben_cwb_group_hrchy hrchy
1280: where hrchy.emp_per_in_ler_id = pil.per_in_ler_id
1281: and hrchy.lvl_num = 1) ;
1282: --
1283: l_group_business_group_id number;

Line 2049: from ben_cwb_group_hrchy

2045: where s.group_per_in_ler_id = p_group_per_in_ler_id;
2046: --
2047: cursor csr_mgr_pil_ids is
2048: select mgr_per_in_ler_id
2049: from ben_cwb_group_hrchy
2050: where emp_per_in_ler_id = p_group_per_in_ler_id
2051: and lvl_num > 0;
2052: --
2053: begin