APPS.BEN_CWB_BACK_OUT_CONC dependencies on BEN_CWB_GROUP_HRCHY

Line 105: from ben_cwb_group_hrchy

101: (p_per_in_ler_id in number
102: ) is
103: cursor c_chr is
104: select rowid
105: from ben_cwb_group_hrchy
106: where mgr_per_in_ler_id = p_per_in_ler_id;
107: --
108: l_proc varchar2(50) := g_package||'.cwb_delete_routine';
109: begin

Line 115: delete from ben_cwb_group_hrchy hrc

111: hr_utility.set_location( 'Entering '|| l_proc, 5);
112: --
113: -- Delete heirarchy data : bug 4021004
114: --
115: delete from ben_cwb_group_hrchy hrc
116: where emp_per_in_ler_id = p_per_in_ler_id;
117: --
118: -- Now delete all the data where this per in ler id is manager
119: --

Line 122: update ben_cwb_group_hrchy set

118: -- Now delete all the data where this per in ler id is manager
119: --
120: for l_chr in c_chr loop
121: begin
122: update ben_cwb_group_hrchy set
123: mgr_per_in_ler_id = -1 ,
124: LVL_NUM = -1
125: where rowid = l_chr.rowid;
126: exception

Line 143: from ben_cwb_group_hrchy

139: (p_per_in_ler_id in number
140: ) is
141: cursor c_chr is
142: select rowid, emp_per_in_ler_id
143: from ben_cwb_group_hrchy
144: where mgr_per_in_ler_id = p_per_in_ler_id;
145: --
146: l_proc varchar2(50) := g_package||'.cwb_delete_routine';
147: begin

Line 153: delete from ben_cwb_group_hrchy hrc

149: hr_utility.set_location( 'Entering '|| l_proc, 5);
150: --
151: -- Delete heirarchy data : bug 4021004
152: --
153: delete from ben_cwb_group_hrchy hrc
154: where emp_per_in_ler_id = p_per_in_ler_id;
155: --
156: -- Now delete all the data where this per in ler id is manager
157: --

Line 160: update ben_cwb_group_hrchy set

156: -- Now delete all the data where this per in ler id is manager
157: --
158: for l_chr in c_chr loop
159: begin
160: update ben_cwb_group_hrchy set
161: mgr_per_in_ler_id = -1 ,
162: LVL_NUM = -1
163: where rowid = l_chr.rowid;
164: --

Line 165: delete from ben_cwb_group_hrchy

161: mgr_per_in_ler_id = -1 ,
162: LVL_NUM = -1
163: where rowid = l_chr.rowid;
164: --
165: delete from ben_cwb_group_hrchy
166: where emp_per_in_ler_id = l_chr.emp_per_in_ler_id
167: and LVL_NUM > -1;
168: --
169: exception

Line 1200: from ben_cwb_group_hrchy hrchy

1196: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')
1197: and pil.ws_mgr_id is not null
1198: and pil.per_in_ler_id = inf.group_per_in_ler_id
1199: and not exists (select 'Y'
1200: from ben_cwb_group_hrchy hrchy
1201: where hrchy.emp_per_in_ler_id = pil.per_in_ler_id
1202: and hrchy.lvl_num = 1) ;
1203: --
1204: l_group_business_group_id number;

Line 1955: from ben_cwb_group_hrchy

1951: where s.group_per_in_ler_id = p_group_per_in_ler_id;
1952: --
1953: cursor csr_mgr_pil_ids is
1954: select mgr_per_in_ler_id
1955: from ben_cwb_group_hrchy
1956: where emp_per_in_ler_id = p_group_per_in_ler_id
1957: and lvl_num > 0;
1958: --
1959: begin