[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
3082: fetch c_opt into l_opt;
3083: close c_opt;
3084: end if;
3085: --
3086: l_outputs := benutils.formula
3087: (p_formula_id => p_formula_id
3088: ,p_pgm_id => p_pgm_id
3089: ,p_pl_id => p_pl_id
3090: ,p_pl_typ_id => p_pl_typ_id
3165: l_ctfns_defined boolean := FALSE;
3166: l_ff_ctfns_exists boolean := FALSE ; -- Bug1491912
3167: l_susp_if_ctfn_not_prvd_flag varchar2(30);
3168:
3169: -- Cursor to select context parameters for benutils.formula
3170:
3171: cursor c_rslt is
3172: select rslt.pgm_id,
3173: rslt.ptip_id,
3467: close c_asg;
3468: end if;
3469: --
3470:
3471: /* -- 4031733 - Cursor used to populate l_state.region_2 param for benutils.limit_checks
3472: -- which is not used down the line
3473: --
3474: if l_rslt.person_id is not null then
3475: open c_state;
8241:
8242: CLOSE c_opt;
8243:
8244: l_outputs :=
8245: benutils.formula
8246: (p_formula_id => l_ctfn_rec.ctrrl,
8247: p_pgm_id => pen_info_rec.pgm_id,
8248: p_pl_id => pen_info_rec.pl_id,
8249: p_pl_typ_id => pen_info_rec.pl_typ_id,
9014: fetch c_opt into l_opt;
9015: close c_opt;
9016: end if;
9017: --
9018: l_outputs := benutils.formula
9019: (p_formula_id => l_nsc_ctfn_pl.ctrrl
9020: ,p_pgm_id => NULL
9021: ,p_pl_id => l_nsc_ctfn_pl.pl_id
9022: ,p_pl_typ_id => l_rslt.pl_typ_id