APPS.BEN_CWB_DATA_MODEL_UPGRADE dependencies on BEN_CWB_SUMMARY

Line 1433: from ben_cwb_summary summ

1429: ,pl.lf_evt_ocrd_dt
1430: from ben_cwb_pl_dsgn pl
1431: where pl.pl_id = pl.group_pl_id
1432: and not exists (select 'Y'
1433: from ben_cwb_summary summ
1434: where summ.group_pl_id = pl.group_pl_id
1435: and summ.lf_evt_ocrd_dt = pl.lf_evt_ocrd_dt);
1436:
1437:

Line 1458: ben_cwb_summary_pkg.refresh_summary_group_pl

1454: commit_and_log('Refresh Person Info Done for ' ||
1455: to_char(l_plans.group_pl_id) || ' Date ' ||
1456: to_char(l_plans.lf_evt_ocrd_dt, 'yyyy/mm/dd'));
1457:
1458: ben_cwb_summary_pkg.refresh_summary_group_pl
1459: (p_group_pl_id => l_plans.group_pl_id
1460: ,p_lf_evt_ocrd_dt => l_plans.lf_evt_ocrd_dt);
1461:
1462: commit_and_log('Refresh Summary Done for ' ||