APPS.BEN_CWB_DATA_MODEL_UPGRADE dependencies on BEN_CWB_WKSHT_GRP

Line 91: from ben_cwb_wksht_grp tk

87:
88: cursor c_tasks(v_pl_id number) is
89: select min(tk.ordr_num) min_ordr
90: ,max(tk.ordr_num) max_ordr
91: from ben_cwb_wksht_grp tk
92: where tk.pl_id = v_pl_id;
93:
94:
95: cursor c_oipl(v_pl_id number) is

Line 201: update ben_cwb_wksht_grp grp

197: close c_tasks;
198:
199: if l_task_exist then
200:
201: update ben_cwb_wksht_grp grp
202: set grp.status_cd = 'A'
203: ,grp.hidden_cd = null
204: where grp.pl_id = l_pl_dsgn.pl_id;
205:

Line 222: insert into ben_cwb_wksht_grp

218: end if;
219:
220:
221: if l_pl_dsgn.uses_bdgt_flag = 'Y' then
222: insert into ben_cwb_wksht_grp
223: (cwb_wksht_grp_id ,business_group_id
224: ,pl_id ,ordr_num ,wksht_grp_cd ,label
225: ,status_cd ,hidden_cd ,object_version_number)
226: values

Line 227: (ben_cwb_wksht_grp_s.nextval ,l_pl_dsgn.business_group_id

223: (cwb_wksht_grp_id ,business_group_id
224: ,pl_id ,ordr_num ,wksht_grp_cd ,label
225: ,status_cd ,hidden_cd ,object_version_number)
226: values
227: (ben_cwb_wksht_grp_s.nextval ,l_pl_dsgn.business_group_id
228: ,l_pl_dsgn.pl_id ,l_min_ordr
229: ,'BDGT' ,'Set Budgets' ,'A' ,null ,1);
230: end if;
231:

Line 233: insert into ben_cwb_wksht_grp

229: ,'BDGT' ,'Set Budgets' ,'A' ,null ,1);
230: end if;
231:
232: if not(l_task_exist) then
233: insert into ben_cwb_wksht_grp
234: (cwb_wksht_grp_id ,business_group_id
235: ,pl_id ,ordr_num ,wksht_grp_cd ,label
236: ,status_cd ,hidden_cd ,object_version_number)
237: values

Line 238: (ben_cwb_wksht_grp_s.nextval ,l_pl_dsgn.business_group_id

234: (cwb_wksht_grp_id ,business_group_id
235: ,pl_id ,ordr_num ,wksht_grp_cd ,label
236: ,status_cd ,hidden_cd ,object_version_number)
237: values
238: (ben_cwb_wksht_grp_s.nextval ,l_pl_dsgn.business_group_id
239: ,l_pl_dsgn.pl_id ,l_max_ordr ,'COMP'
240: ,'Allocate Compensation' ,'A' ,null ,1);
241: l_max_ordr := l_max_ordr + 10;
242: end if;

Line 245: insert into ben_cwb_wksht_grp

241: l_max_ordr := l_max_ordr + 10;
242: end if;
243:
244:
245: insert into ben_cwb_wksht_grp
246: (cwb_wksht_grp_id ,business_group_id
247: ,pl_id ,ordr_num ,wksht_grp_cd ,label
248: ,status_cd ,hidden_cd ,object_version_number)
249: values

Line 250: (ben_cwb_wksht_grp_s.nextval ,l_pl_dsgn.business_group_id

246: (cwb_wksht_grp_id ,business_group_id
247: ,pl_id ,ordr_num ,wksht_grp_cd ,label
248: ,status_cd ,hidden_cd ,object_version_number)
249: values
250: (ben_cwb_wksht_grp_s.nextval ,l_pl_dsgn.business_group_id
251: ,l_pl_dsgn.pl_id ,l_max_ordr ,'APPR'
252: ,'Manage Approvals' ,'A' ,null ,1);
253: l_max_ordr := l_max_ordr + 10;
254:

Line 255: insert into ben_cwb_wksht_grp

251: ,l_pl_dsgn.pl_id ,l_max_ordr ,'APPR'
252: ,'Manage Approvals' ,'A' ,null ,1);
253: l_max_ordr := l_max_ordr + 10;
254:
255: insert into ben_cwb_wksht_grp
256: (cwb_wksht_grp_id ,business_group_id
257: ,pl_id ,ordr_num ,wksht_grp_cd ,label
258: ,status_cd ,hidden_cd ,object_version_number)
259: values

Line 260: (ben_cwb_wksht_grp_s.nextval ,l_pl_dsgn.business_group_id

256: (cwb_wksht_grp_id ,business_group_id
257: ,pl_id ,ordr_num ,wksht_grp_cd ,label
258: ,status_cd ,hidden_cd ,object_version_number)
259: values
260: (ben_cwb_wksht_grp_s.nextval ,l_pl_dsgn.business_group_id
261: ,l_pl_dsgn.pl_id ,l_max_ordr ,'RVW'
262: ,'Review and Submit' ,'A' ,null ,1);
263:
264: end if; -- pl_id <> old_pl_id

Line 857: from ben_cwb_wksht_grp tk

853: ,'RVW', decode(popl.ws_stat_cd, 'PR','CO','AP', 'CO', 'NS')
854: ,decode(popl.ws_stat_cd,'IP','IP','PR','CO','PA','CO','CO','CO','NS')
855: ) status_cd
856: ,1
857: from ben_cwb_wksht_grp tk
858: ,ben_per_in_ler pil
859: ,ben_pil_elctbl_chc_popl popl
860: where pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')
861: and pil.group_pl_id is null