[Home] [Help]
117: 115.32 09-Jul-99 bbulusu Added checks for backed out nocopy life evts.
118: 115.33 14-Jul-99 maagrawa Corrected opening of cursor c_nsc_ctfn_pl.
119: Use of bnf_ctfn_rqd_flag and
120: dpnt_dsgn_no_ctfn_rqd_flag negated.
121: 115.34 20-JUL-99 Gperry genutils -> benutils package rename.
122: 115.35 24-Aug-99 maagrawa Changes related to breaking of dependents
123: table.
124: 115.36 07-Sep-99 tguy fixed call to pay_mag_util
125: 115.37 27-Sep-99 maagrawa Modified Check procedures for prtt, dpnt,
211: 115.71 17-May-01 maagrawa More Performance changes.
212: 115.72 17-May-01 maagrawa Added exit statement.
213: 115.73 02-Jul-01 kmahendr Bug#1842614- increased l_pln_name variable to 80
214: 115.74 27-aug-01 tilak bug:1949361 jurisdiction code is
215: derived inside benutils.formula.
216: 115.75 26-Dec-01 pabodla bug:1857685 - Do not create dependent and
217: beneficiary related action items for
218: waive plans and options.
219: 115.76 08-FEB-02 aprabhak added an action item for future salary
3095: fetch c_opt into l_opt;
3096: close c_opt;
3097: end if;
3098: --
3099: l_outputs := benutils.formula
3100: (p_formula_id => p_formula_id
3101: ,p_pgm_id => p_pgm_id
3102: ,p_pl_id => p_pl_id
3103: ,p_pl_typ_id => p_pl_typ_id
3178: l_ctfns_defined boolean := FALSE;
3179: l_ff_ctfns_exists boolean := FALSE ; -- Bug1491912
3180: l_susp_if_ctfn_not_prvd_flag varchar2(30);
3181:
3182: -- Cursor to select context parameters for benutils.formula
3183:
3184: cursor c_rslt is
3185: select rslt.pgm_id,
3186: rslt.ptip_id,
3480: close c_asg;
3481: end if;
3482: --
3483:
3484: /* -- 4031733 - Cursor used to populate l_state.region_2 param for benutils.limit_checks
3485: -- which is not used down the line
3486: --
3487: if l_rslt.person_id is not null then
3488: open c_state;
8326:
8327: CLOSE c_opt;
8328:
8329: l_outputs :=
8330: benutils.formula
8331: (p_formula_id => l_ctfn_rec.ctrrl,
8332: p_pgm_id => pen_info_rec.pgm_id,
8333: p_pl_id => pen_info_rec.pl_id,
8334: p_pl_typ_id => pen_info_rec.pl_typ_id,
9099: fetch c_opt into l_opt;
9100: close c_opt;
9101: end if;
9102: --
9103: l_outputs := benutils.formula
9104: (p_formula_id => l_nsc_ctfn_pl.ctrrl
9105: ,p_pgm_id => NULL
9106: ,p_pl_id => l_nsc_ctfn_pl.pl_id
9107: ,p_pl_typ_id => l_rslt.pl_typ_id