APPS.BEN_CWB_BACK_OUT_CONC dependencies on BEN_CWB_PL_DSGN

Line 30: ben_cwb_pl_dsgn

26: participation process.
27: 26-Mar-04 pbodla 115.8 Added code to delete
28: BEN_CWB_PERSON_INFO,
29: BEN_CWB_SUMMARY,
30: ben_cwb_pl_dsgn
31: 26-Mar-04 pbodla 115.9 l_ocrd_date need to be passed to
32: BEN_CWB_PL_DSGN_PKG.delete_pl_dsgn
33: 27-Apr-04 rpgupta 115.13 bug 3517726 - elete records in ben_cwb_person_rates
34: with the given group_pl_id, ler_id and life event

Line 32: BEN_CWB_PL_DSGN_PKG.delete_pl_dsgn

28: BEN_CWB_PERSON_INFO,
29: BEN_CWB_SUMMARY,
30: ben_cwb_pl_dsgn
31: 26-Mar-04 pbodla 115.9 l_ocrd_date need to be passed to
32: BEN_CWB_PL_DSGN_PKG.delete_pl_dsgn
33: 27-Apr-04 rpgupta 115.13 bug 3517726 - elete records in ben_cwb_person_rates
34: with the given group_pl_id, ler_id and life event
35: ocrd date. Sometimes when one thread of benmngle
36: fails, theres a possibility that a few records in

Line 574: from ben_cwb_pl_dsgn i

570: ,p_lf_evt_ocrd_dt in date) is
571:
572: cursor c_data_exists is
573: select custom_integrator
574: from ben_cwb_pl_dsgn i
575: where i.group_pl_id = p_group_pl_id
576: and i.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
577: and i.pl_id = i.group_pl_id
578: and i.oipl_id = -1

Line 1625: hr_utility.set_location('Deleting data from ben_cwb_pl_dsgn ',10);

1621: ,P_LF_EVT_OCRD_DT => fnd_date.date_to_canonical(l_ocrd_date)
1622: ,P_PURGE => 'Y');
1623:
1624: --
1625: hr_utility.set_location('Deleting data from ben_cwb_pl_dsgn ',10);
1626: BEN_CWB_PL_DSGN_PKG.delete_pl_dsgn
1627: (p_group_pl_id => p_group_pl_id
1628: ,p_lf_evt_ocrd_dt => l_ocrd_date);
1629: --

Line 1626: BEN_CWB_PL_DSGN_PKG.delete_pl_dsgn

1622: ,P_PURGE => 'Y');
1623:
1624: --
1625: hr_utility.set_location('Deleting data from ben_cwb_pl_dsgn ',10);
1626: BEN_CWB_PL_DSGN_PKG.delete_pl_dsgn
1627: (p_group_pl_id => p_group_pl_id
1628: ,p_lf_evt_ocrd_dt => l_ocrd_date);
1629: --
1630: hr_utility.set_location('Refreshing Summary ',20);