[Home] [Help]
3498: -- Call formula initialise routine
3499: -- assignment condition is removed, with this conidtion dpnt can not be called for the formula
3500: -- user need formula to get person level data for dpnt
3501: --if l_asg.assignment_id is not null then
3502: l_outputs := benutils.formula
3503: (p_formula_id => p_data_elmt_rl,
3504: p_effective_date => ben_ext_person.g_person_ext_dt,
3505: p_assignment_id => l_asg.assignment_id,
3506: p_organization_id => l_asg.organization_id,
3529: --
3530: elsif l_rule_type.formula_type_id = -531 then -- Enrollment Level rule
3531: -- Call formula initialise routine
3532: hr_utility.set_location('g_enrt_prtt_enrt_rslt_id' ||ben_ext_person.g_enrt_prtt_enrt_rslt_id, 886) ;
3533: l_outputs := benutils.formula
3534: (p_formula_id => p_data_elmt_rl,
3535: p_effective_date => ben_ext_person.g_benefits_ext_dt,
3536: p_assignment_id => l_asg.assignment_id,
3537: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3560: l_rslt_elmt := l_outputs(l_outputs.first).value;
3561: --
3562: elsif l_rule_type.formula_type_id = -536 then -- Eligible Level Rule
3563: -- Call formula initialise routine
3564: l_outputs := benutils.formula
3565: (p_formula_id => p_data_elmt_rl,
3566: p_effective_date => ben_ext_person.g_benefits_ext_dt,
3567: p_assignment_id => l_asg.assignment_id,
3568: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3582: --
3583: elsif l_rule_type.formula_type_id = -537 then -- Premium Level Rule
3584: hr_utility.set_location(' Rule537:'||l_proc, 35);
3585: -- Call formula initialise routine
3586: l_outputs := benutils.formula
3587: (p_formula_id => p_data_elmt_rl,
3588: p_effective_date => ben_ext_person.g_benefits_ext_dt,
3589: p_assignment_id => l_asg.assignment_id,
3590: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3605: l_rslt_elmt := l_outputs(l_outputs.first).value;
3606: --
3607: elsif l_rule_type.formula_type_id = -538 then -- Dependnt Level Rule
3608: -- Call formula initialise routine
3609: l_outputs := benutils.formula
3610: (p_formula_id => p_data_elmt_rl,
3611: p_effective_date => ben_ext_person.g_benefits_ext_dt,
3612: p_assignment_id => l_asg.assignment_id,
3613: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3626: l_rslt_elmt := l_outputs(l_outputs.first).value;
3627: --
3628: elsif l_rule_type.formula_type_id = -539 then -- Action Item Level Rule
3629: -- Call formula initialise routine
3630: l_outputs := benutils.formula
3631: (p_formula_id => p_data_elmt_rl,
3632: p_effective_date => ben_ext_person.g_benefits_ext_dt,
3633: p_assignment_id => l_asg.assignment_id,
3634: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3646: l_rslt_elmt := l_outputs(l_outputs.first).value;
3647: --
3648: elsif l_rule_type.formula_type_id = -540 then -- Beneficiary level Rule
3649: -- Call formula initialise routine
3650: l_outputs := benutils.formula
3651: (p_formula_id => p_data_elmt_rl,
3652: p_effective_date => ben_ext_person.g_benefits_ext_dt,
3653: p_assignment_id => l_asg.assignment_id,
3654: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3667: l_rslt_elmt := l_outputs(l_outputs.first).value;
3668: --
3669: elsif l_rule_type.formula_type_id = -541 then -- Flex credit level Rule
3670: -- Call formula initialise routine
3671: l_outputs := benutils.formula
3672: (p_formula_id => p_data_elmt_rl,
3673: p_effective_date => ben_ext_person.g_benefits_ext_dt,
3674: p_assignment_id => l_asg.assignment_id,
3675: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3689: l_rslt_elmt := l_outputs(l_outputs.first).value;
3690: --
3691: elsif l_rule_type.formula_type_id = -542 then -- payroll level Rule
3692: -- Call formula initialise routine
3693: l_outputs := benutils.formula
3694: (p_formula_id => p_data_elmt_rl,
3695: p_effective_date => ben_ext_person.g_benefits_ext_dt,
3696: p_assignment_id => l_asg.assignment_id,
3697: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3711: l_rslt_elmt := l_outputs(l_outputs.first).value;
3712: --
3713: elsif l_rule_type.formula_type_id = -543 then -- runresult level Rule
3714: -- Call formula initialise routine
3715: l_outputs := benutils.formula
3716: (p_formula_id => p_data_elmt_rl,
3717: p_effective_date => ben_ext_person.g_benefits_ext_dt,
3718: p_assignment_id => l_asg.assignment_id,
3719: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3738: l_rslt_elmt := l_outputs(l_outputs.first).value;
3739: --
3740: elsif l_rule_type.formula_type_id = -544 then -- contact level Rule
3741: -- Call formula initialise routine
3742: l_outputs := benutils.formula
3743: (p_formula_id => p_data_elmt_rl,
3744: p_effective_date => ben_ext_person.g_benefits_ext_dt,
3745: p_assignment_id => l_asg.assignment_id,
3746: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3760: l_rslt_elmt := l_outputs(l_outputs.first).value;
3761: --
3762: elsif l_rule_type.formula_type_id = -545 then -- elig dpnt level Rule
3763: -- Call formula initialise routine
3764: l_outputs := benutils.formula
3765: (p_formula_id => p_data_elmt_rl,
3766: p_effective_date => ben_ext_person.g_benefits_ext_dt,
3767: p_assignment_id => l_asg.assignment_id,
3768: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3781: --
3782: l_rslt_elmt := l_outputs(l_outputs.first).value;
3783:
3784: elsif l_rule_type.formula_type_id = -546 then -- subheader level rule
3785: l_outputs := benutils.formula
3786: (p_formula_id => p_data_elmt_rl,
3787: p_effective_date => p_effective_date ,
3788: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id)
3789: ,p_param1 => 'EXT_DFN_ID'