APPS.BEN_ELECTION_INFORMATION dependencies on BEN_LE_CLSN_N_RSTR

Line 489: is captured in ben_le_clsn_n_rstr table

485: 11-jan-06 ikasire 115.231 4938498 fixed c_prv2 cursor to exclude voided and backedout
486: records.
487: 16-Jan-06 abparekh 115.232 Bug 4954541 : If bnft_amt is nullified, create new enrollment
488: 10-Feb-06 kmahendr 115.233 Bug#5032364 - before delete prtt row, it
489: is captured in ben_le_clsn_n_rstr table
490: for backout purpose
491: 22-Mar-06 rtagarra 115.234 Bug#5099296 : Changed the sspndd_flag parameter passed to update_enrollment.
492: 23-Mar-06 kmahendr 115.235 Bug#5105122 - coverage date is recomputed
493: before create_enrollment

Line 501: 10-Oct-06 abparekh 115.241 Bug 5572484 : Take backup in BEN_LE_CLSN_N_RSTR only if the correction

497: 17-jul-06 ssarkar 115.238 Bug 5375381 - ben_determine_activity_base_rt being called for interim.
498: 03-aug-06 ssarkar 115.239 bug 5417132 - passing comp_lvl_cd to update_enrollment call
499: 27-Sep-06 ikasired 115.240 Bug 5502202 fix for Interim Rule. We need to recompute the rates when
500: interim rule returs amounts.
501: 10-Oct-06 abparekh 115.241 Bug 5572484 : Take backup in BEN_LE_CLSN_N_RSTR only if the correction
502: is due to a new life event.
503: 11-Oct-06 ssarkar 115.242 Bug 5555269 - commented out fix of bug 5032364 as well 5572484
504: 12-Oct-06 gsehgal 115.243 Bug 5584813 - move the code to calculate rates to procedure
505: calc_rt_ann_rt_vals and also call this when cvg_mlt_cd='SAAEAR'

Line 1440: from ben_le_clsn_n_rstr

1436: --
1437: cursor c_prtt_rt_val_adj (p_per_in_ler_id number,
1438: p_prtt_rt_val_id number) is
1439: select null
1440: from ben_le_clsn_n_rstr
1441: where BKUP_TBL_TYP_CD = 'BEN_PRTT_RT_VAL_ADJ'
1442: AND BKUP_TBL_ID = p_prtt_rt_val_id
1443: AND PER_IN_LER_ID = p_per_in_ler_id;
1444: --

Line 3352: insert into BEN_LE_CLSN_N_RSTR (

3348: --
3349: open c_prtt_rt_val_adj(p_per_in_ler_id,l_pen.prtt_rt_val_id);
3350: fetch c_prtt_rt_val_adj into l_exists;
3351: if c_prtt_rt_val_adj%notfound then
3352: insert into BEN_LE_CLSN_N_RSTR (
3353: BKUP_TBL_TYP_CD,
3354: BKUP_TBL_ID,
3355: per_in_ler_id,
3356: person_id,

Line 3522: insert into BEN_LE_CLSN_N_RSTR (

3518: --
3519: open c_prtt_rt_val_adj(p_per_in_ler_id,l_pen.prtt_rt_val_id);
3520: fetch c_prtt_rt_val_adj into l_exists;
3521: if c_prtt_rt_val_adj%notfound then
3522: insert into BEN_LE_CLSN_N_RSTR (
3523: BKUP_TBL_TYP_CD,
3524: BKUP_TBL_ID,
3525: per_in_ler_id,
3526: person_id,

Line 4631: from ben_le_clsn_n_rstr leclr, ben_elig_per_elctbl_chc epe

4627: and ptip.effective_end_date;
4628: --
4629: cursor c_prtt_enrt_rslt_adj (p_prtt_enrt_rslt_id number) is
4630: select null
4631: from ben_le_clsn_n_rstr leclr, ben_elig_per_elctbl_chc epe
4632: where leclr.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_RSLT_F_ADJ'
4633: AND leclr.BKUP_TBL_ID = p_prtt_enrt_rslt_id
4634: AND leclr.PER_IN_LER_ID = epe.per_in_ler_id
4635: AND epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;

Line 5277: -- Bug 5572484 : Take backup in BEN_LE_CLSN_N_RSTR only if the correction

5273: open c_enrt_rslt2;
5274: fetch c_enrt_rslt2 into l_enrt_rslt2;
5275: close c_enrt_rslt2;
5276: --
5277: -- Bug 5572484 : Take backup in BEN_LE_CLSN_N_RSTR only if the correction
5278: -- is due to a new life event. E.g. If you de-enrol in a life
5279: -- event and again enrol in the same life event, then we need
5280: -- not take backup of the de-enrolled PEN
5281: --

Line 5285: insert into BEN_LE_CLSN_N_RSTR (

5281: --
5282: if nvl(l_old_per_in_ler_id, -999) <> l_global_epe_rec.per_in_ler_id
5283: then
5284: --
5285: insert into BEN_LE_CLSN_N_RSTR (
5286: BKUP_TBL_TYP_CD,
5287: COMP_LVL_CD,
5288: LCR_ATTRIBUTE16,
5289: LCR_ATTRIBUTE17,

Line 6163: insert into BEN_LE_CLSN_N_RSTR (

6159: --
6160: open c_prtt_enrt_rslt_adj(l_get_enrt_rslts_for_pen.prtt_enrt_rslt_id);
6161: fetch c_prtt_enrt_rslt_adj into l_exists;
6162: if c_prtt_enrt_rslt_adj%notfound then
6163: insert into BEN_LE_CLSN_N_RSTR (
6164: BKUP_TBL_TYP_CD,
6165: BKUP_TBL_ID,
6166: per_in_ler_id,
6167: person_id,