[Home] [Help]
98: _fulltime procedure.
99: 24-Aug-98 G Perry 110.31 Fixed 'STTDCOMP' for calulating
100: comp level. Reorganised some
101: code, improved calling to use
102: ben_determine_date.
103: 26-Aug-98 G Perry 115.12 Changed comb_age_and_los to
104: return cache structure frozen
105: value.
106: 28-Aug-98 G Perry 115.13 Removed storing of old temporal
228: 15-NOV-1999 STee 115.58 Fix due date for subsequent
229: payments.
230: 19-NOV-1999 GPERRY 115.59 Added new flags.
231: 22-NOV-1999 pbodla 115.60 Bug 3299 : Passed bnfts_bal_id to
232: ben_determine_date.main when
233: comp_lvl_det_cd, hrs_wkd_det_cd
234: are evaluated.
235: 09-DEC-1999 pbodla 115.61 - Bug 3034 : When age, los, hwf, comp
236: are calculated the rules are passed
233: comp_lvl_det_cd, hrs_wkd_det_cd
234: are evaluated.
235: 09-DEC-1999 pbodla 115.61 - Bug 3034 : When age, los, hwf, comp
236: are calculated the rules are passed
237: to ben_determine_date.main.
238: - min_max_breach : added formula_id
239: parameter.
240: 22-Dec-1999 lmcdonal 115.62 Add comment and remove duplicate
241: join in get_pymt.
2122: -- as it will reset the date to the life event occured on date.
2123: --
2124: IF p_det_cd <> 'AED' THEN
2125: --
2126: ben_determine_date.main(p_date_cd=> p_det_cd
2127: ,p_formula_id => p_formula_id
2128: ,p_person_id => p_person_id
2129: ,p_pgm_id => NVL(p_pgm_id
2130: ,p_comp_obj_tree_row.par_pgm_id)
2174: END IF;
2175: --
2176: -- Reapply logic back to determination of date routine.
2177: --
2178: ben_determine_date.main(p_date_cd=> l_det_cd
2179: ,p_formula_id => p_formula_id
2180: ,p_person_id => p_person_id
2181: ,p_pgm_id => NVL(p_pgm_id
2182: ,p_comp_obj_tree_row.par_pgm_id)
2343: l_oiplip_rec := p_curroiplip_row;
2344: --
2345: END IF;
2346: --
2347: ben_determine_date.main(p_date_cd=> p_rec.los_det_cd
2348: ,p_formula_id => p_rec.los_det_rl
2349: ,p_person_id => p_person_id
2350: ,p_pgm_id => NVL(p_pgm_id
2351: ,p_comp_obj_tree_row.par_pgm_id)
2955: --
2956: if g_debug then
2957: hr_utility.set_location(' BDD_Mn ' || l_package,10);
2958: end if;
2959: ben_determine_date.main(p_date_cd=> p_rec.age_det_cd
2960: ,p_formula_id => p_rec.age_det_rl
2961: ,p_person_id => p_person_id
2962: ,p_pgm_id => NVL(p_pgm_id
2963: ,p_comp_obj_tree_row.par_pgm_id)
3088: l_oiplip_rec := p_curroiplip_row;
3089: --
3090: END IF;
3091: --
3092: ben_determine_date.main(p_date_cd=> p_rec.hrs_wkd_det_cd
3093: ,p_formula_id => p_rec.hrs_wkd_det_rl
3094: ,p_person_id => p_person_id
3095: ,p_bnfts_bal_id => p_rec.bnfts_bal_id
3096: ,p_pgm_id => NVL(p_pgm_id
3435: l_oiplip_rec := p_curroiplip_row;
3436: --
3437: END IF;
3438: --
3439: ben_determine_date.main(p_date_cd=> p_rec.comp_lvl_det_cd
3440: ,p_formula_id => p_rec.comp_lvl_det_rl
3441: ,p_person_id => p_person_id
3442: ,p_pgm_id => NVL(p_pgm_id
3443: ,p_comp_obj_tree_row.par_pgm_id)
3868: IF l_elig_rec.exist = 'Y' THEN
3869: -- los based on los_calc_rl takes precedence
3870: IF l_elig_rec.los_calc_rl IS NOT NULL THEN
3871: --
3872: ben_determine_date.main(p_date_cd=> l_elig_rec.los_det_cd
3873: ,p_formula_id => l_elig_rec.los_det_rl
3874: ,p_person_id => p_person_id
3875: ,p_pgm_id => NVL(p_pgm_id
3876: ,p_comp_obj_tree_row.par_pgm_id)
4071: --
4072: -- los based on los_calc_rl takes precedence
4073: IF l_rate_rec.los_calc_rl IS NOT NULL THEN
4074: --
4075: ben_determine_date.main(p_date_cd=> l_rate_rec.los_det_cd
4076: ,p_formula_id => l_rate_rec.los_det_rl
4077: ,p_person_id => p_person_id
4078: ,p_pgm_id => NVL(p_pgm_id
4079: ,p_comp_obj_tree_row.par_pgm_id)
4206: --
4207: -- los based on los_calc_rl takes precedence
4208: IF l_rate_cvg_rec.los_calc_rl IS NOT NULL THEN
4209: --
4210: ben_determine_date.main(p_date_cd=> l_rate_cvg_rec.los_det_cd
4211: ,p_formula_id => l_rate_cvg_rec.los_det_rl
4212: ,p_person_id => p_person_id
4213: ,p_pgm_id => NVL(p_pgm_id
4214: ,p_comp_obj_tree_row.par_pgm_id)
4338: l_prem := TRUE;
4339: -- los based on los_calc_rl takes precedence
4340: IF l_rate_prem_rec.los_calc_rl IS NOT NULL THEN
4341: --
4342: ben_determine_date.main(p_date_cd=> l_rate_prem_rec.los_det_cd
4343: ,p_formula_id => l_rate_prem_rec.los_det_rl
4344: ,p_person_id => p_person_id
4345: ,p_pgm_id => NVL(p_pgm_id
4346: ,p_comp_obj_tree_row.par_pgm_id)
5210: /* BUG: 4380180. IF l_lf_evt_ocrd_dt IS NULL, avoid determining the date */
5211: IF (p_det_cd <> 'AED' AND l_lf_evt_ocrd_dt IS NOT NULL) THEN
5212: --
5213:
5214: ben_determine_date.main(p_date_cd=> p_det_cd
5215: ,p_formula_id => p_formula_id
5216: ,p_person_id => p_person_id
5217: ,p_bnfts_bal_id => p_bnfts_bal_id
5218: ,p_pgm_id => NVL(p_pgm_id
5265: END IF;
5266: --
5267: -- Reapply logic back to determination of date routine.
5268: --
5269: ben_determine_date.main(p_date_cd=> l_det_cd
5270: ,p_bnfts_bal_id => p_bnfts_bal_id
5271: ,p_person_id => p_person_id
5272: ,p_pgm_id => NVL(p_pgm_id
5273: ,p_comp_obj_tree_row.par_pgm_id)
5300: ,p_break => l_break);
5301: --
5302: IF p_det_cd <> 'AED' THEN
5303: --
5304: ben_determine_date.main(p_date_cd=> p_det_cd
5305: ,p_formula_id => p_formula_id
5306: ,p_person_id => p_person_id
5307: ,p_bnfts_bal_id => p_bnfts_bal_id
5308: ,p_pgm_id => NVL(p_pgm_id
5352: END IF;
5353: --
5354: -- Reapply logic back to determination of date routine.
5355: --
5356: ben_determine_date.main(p_date_cd=> l_det_cd
5357: ,p_bnfts_bal_id => p_bnfts_bal_id
5358: ,p_person_id => p_person_id
5359: ,p_pgm_id => NVL(p_pgm_id
5360: ,p_comp_obj_tree_row.par_pgm_id)
5667: -- Rule takes precedence
5668: -- hr_utility.set_location(' Elig exists ' || l_package,10);
5669: IF l_elig_rec.comp_calc_rl IS NOT NULL THEN
5670: --
5671: ben_determine_date.main(p_date_cd=> l_elig_rec.comp_lvl_det_cd
5672: ,p_formula_id => l_elig_rec.comp_lvl_det_rl
5673: ,p_person_id => p_person_id
5674: ,p_pgm_id => NVL(p_pgm_id
5675: ,p_comp_obj_tree_row.par_pgm_id)
5830: -- Reapply life event date logic to derived date
5831: --
5832: IF l_elig_rec.comp_lvl_det_cd <> 'AED' THEN
5833: --
5834: ben_determine_date.main(p_date_cd=> l_elig_rec.comp_lvl_det_cd
5835: ,p_formula_id => l_elig_rec.comp_lvl_det_rl
5836: ,p_person_id => p_person_id
5837: ,p_bnfts_bal_id => l_elig_rec.bnfts_bal_id
5838: ,p_pgm_id => NVL(p_pgm_id
5880: END IF;
5881: --
5882: -- Reapply logic back to determination of date routine.
5883: --
5884: ben_determine_date.main(p_date_cd=> l_elig_rec.comp_lvl_det_cd
5885: ,p_bnfts_bal_id => l_elig_rec.bnfts_bal_id
5886: ,p_person_id => p_person_id
5887: ,p_pgm_id => NVL(p_pgm_id
5888: ,p_comp_obj_tree_row.par_pgm_id)
5912: ,p_break => l_break);
5913: --
5914: IF l_elig_rec.comp_lvl_det_cd <> 'AED' THEN
5915: --
5916: ben_determine_date.main(p_date_cd=> l_elig_rec.comp_lvl_det_cd
5917: ,p_formula_id => l_elig_rec.comp_lvl_det_rl
5918: ,p_bnfts_bal_id => l_elig_rec.bnfts_bal_id
5919: ,p_person_id => p_person_id
5920: ,p_pgm_id => NVL(p_pgm_id
5962: END IF;
5963: --
5964: -- Reapply logic back to determination of date routine.
5965: --
5966: ben_determine_date.main(p_date_cd=> l_elig_rec.comp_lvl_det_cd
5967: ,p_bnfts_bal_id => l_elig_rec.bnfts_bal_id
5968: ,p_person_id => p_person_id
5969: ,p_pgm_id => NVL(p_pgm_id
5970: ,p_comp_obj_tree_row.par_pgm_id)
6114: if g_debug then
6115: hr_utility.set_location('in the comp_calc_rl ' ,30);
6116: end if;
6117: --
6118: ben_determine_date.main(p_date_cd=> l_rate_rec.comp_lvl_det_cd
6119: ,p_formula_id => l_rate_rec.comp_lvl_det_rl
6120: ,p_person_id => p_person_id
6121: ,p_pgm_id => NVL(p_pgm_id
6122: ,p_comp_obj_tree_row.par_pgm_id)
6316: --
6317: IF l_rate_cvg_rec.comp_calc_rl IS NOT NULL THEN
6318: --
6319:
6320: ben_determine_date.main(p_date_cd=> l_rate_cvg_rec.comp_lvl_det_cd
6321: ,p_formula_id => l_rate_cvg_rec.comp_lvl_det_rl
6322: ,p_person_id => p_person_id
6323: ,p_pgm_id => NVL(p_pgm_id
6324: ,p_comp_obj_tree_row.par_pgm_id)
6507: l_prem := TRUE;
6508: --
6509: IF l_rate_prem_rec.comp_calc_rl IS NOT NULL THEN
6510: --
6511: ben_determine_date.main(p_date_cd=> l_rate_prem_rec.comp_lvl_det_cd
6512: ,p_formula_id => l_rate_prem_rec.comp_lvl_det_rl
6513: ,p_person_id => p_person_id
6514: ,p_pgm_id => NVL(p_pgm_id
6515: ,p_comp_obj_tree_row.par_pgm_id)
8270: -- Reapply calculated life event occured date
8271: --
8272: IF p_det_cd <> 'AED' THEN
8273: --
8274: ben_determine_date.main(p_date_cd=> p_det_cd
8275: ,p_formula_id => p_formula_id
8276: ,p_person_id => p_person_id
8277: ,p_bnfts_bal_id => p_bnfts_bal_id
8278: ,p_pgm_id => NVL(p_pgm_id
8322: END IF;
8323: --
8324: -- Reapply logic back to determination of date routine.
8325: --
8326: ben_determine_date.main(p_date_cd=> l_det_cd
8327: ,p_bnfts_bal_id => p_bnfts_bal_id
8328: ,p_person_id => p_person_id
8329: ,p_pgm_id => NVL(p_pgm_id
8330: ,p_comp_obj_tree_row.par_pgm_id)
8504: if g_debug then
8505: hr_utility.set_location(' l_elig_rec.hrs_wkd_calc_rl '||l_elig_rec.hrs_wkd_calc_rl , 99);
8506: end if;
8507: --
8508: ben_determine_date.main(p_date_cd=> l_elig_rec.hrs_wkd_det_cd
8509: ,p_formula_id => l_elig_rec.hrs_wkd_calc_rl
8510: ,p_person_id => p_person_id
8511: ,p_pgm_id => NVL(p_pgm_id
8512: ,p_comp_obj_tree_row.par_pgm_id)
8651: -- Reapply calculated life event occured date
8652: --
8653: IF l_elig_rec.hrs_wkd_det_cd <> 'AED' THEN
8654: --
8655: ben_determine_date.main(p_date_cd=> l_elig_rec.hrs_wkd_det_cd
8656: ,p_formula_id => l_elig_rec.hrs_wkd_det_rl
8657: ,p_person_id => p_person_id
8658: ,p_bnfts_bal_id => l_elig_rec.bnfts_bal_id
8659: ,p_pgm_id => NVL(p_pgm_id
8700: END IF;
8701: --
8702: -- Reapply logic back to determination of date routine.
8703: --
8704: ben_determine_date.main(p_date_cd=> l_elig_rec.hrs_wkd_det_cd
8705: ,p_bnfts_bal_id => l_elig_rec.bnfts_bal_id
8706: ,p_person_id => p_person_id
8707: ,p_pgm_id => NVL(p_pgm_id
8708: ,p_comp_obj_tree_row.par_pgm_id)
8859: --
8860: if g_debug then
8861: hr_utility.set_location('in the comp_calc_rl ' ,30);
8862: end if;
8863: ben_determine_date.main(p_date_cd=> l_rate_rec.hrs_wkd_det_cd
8864: ,p_formula_id => l_rate_rec.hrs_wkd_calc_rl
8865: ,p_person_id => p_person_id
8866: ,p_pgm_id => NVL(p_pgm_id
8867: ,p_comp_obj_tree_row.par_pgm_id)
9038: l_cvg := TRUE;
9039: --
9040:
9041: IF l_rate_cvg_rec.hrs_wkd_calc_rl IS NOT NULL THEN
9042: ben_determine_date.main(p_date_cd=> l_rate_cvg_rec.hrs_wkd_det_cd
9043: ,p_formula_id => l_rate_cvg_rec.hrs_wkd_calc_rl
9044: ,p_person_id => p_person_id
9045: ,p_pgm_id => NVL(p_pgm_id
9046: ,p_comp_obj_tree_row.par_pgm_id)
9203: l_prem := TRUE;
9204: --
9205: IF l_rate_prem_rec.hrs_wkd_calc_rl IS NOT NULL THEN
9206: --
9207: ben_determine_date.main(p_date_cd=> l_rate_prem_rec.hrs_wkd_det_cd
9208: ,p_formula_id => l_rate_prem_rec.hrs_wkd_calc_rl
9209: ,p_person_id => p_person_id
9210: ,p_pgm_id => NVL(p_pgm_id
9211: ,p_comp_obj_tree_row.par_pgm_id)