APPS.BEN_CWB_DATA_MODEL_UPGRADE dependencies on BEN_CWB_PERSON_GROUPS

Line 353: insert into ben_cwb_person_groups

349:
350: procedure upgrade_person_groups is
351: begin
352:
353: insert into ben_cwb_person_groups
354: (group_per_in_ler_id
355: ,group_pl_id
356: ,group_oipl_id
357: ,lf_evt_ocrd_dt

Line 430: ,ben_cwb_person_groups grp

426: ,1
427: from ben_per_in_ler pil
428: ,ben_pil_elctbl_chc_popl popl
429: ,ben_elig_per_elctbl_chc epe
430: ,ben_cwb_person_groups grp
431: ,ben_enrt_rt db
432: ,ben_enrt_rt wb
433: ,ben_enrt_rt rs
434: where pil.per_in_ler_stat_cd in ('PROCD', 'STRTD')

Line 1441: fnd_stats.gather_table_stats(ownname => 'BEN',tabname => 'BEN_CWB_PERSON_GROUPS');

1437:
1438: begin
1439: commit_and_log('Gather stats started');
1440: fnd_stats.gather_table_stats(ownname => 'BEN',tabname => 'BEN_CWB_GROUP_HRCHY');
1441: fnd_stats.gather_table_stats(ownname => 'BEN',tabname => 'BEN_CWB_PERSON_GROUPS');
1442: fnd_stats.gather_table_stats(ownname => 'BEN',tabname => 'BEN_CWB_PERSON_RATES');
1443: fnd_stats.gather_table_stats(ownname => 'BEN',tabname => 'BEN_CWB_PERSON_INFO');
1444: fnd_stats.gather_table_stats(ownname => 'BEN',tabname => 'BEN_PER_IN_LER');
1445: commit_and_log('Gather stats complete');