[Home] [Help]
3504: -- Call formula initialise routine
3505: -- assignment condition is removed, with this conidtion dpnt can not be called for the formula
3506: -- user need formula to get person level data for dpnt
3507: --if l_asg.assignment_id is not null then
3508: l_outputs := benutils.formula
3509: (p_formula_id => p_data_elmt_rl,
3510: p_effective_date => ben_ext_person.g_person_ext_dt,
3511: p_assignment_id => l_asg.assignment_id,
3512: p_organization_id => l_asg.organization_id,
3535: --
3536: elsif l_rule_type.formula_type_id = -531 then -- Enrollment Level rule
3537: -- Call formula initialise routine
3538: hr_utility.set_location('g_enrt_prtt_enrt_rslt_id' ||ben_ext_person.g_enrt_prtt_enrt_rslt_id, 886) ;
3539: l_outputs := benutils.formula
3540: (p_formula_id => p_data_elmt_rl,
3541: p_effective_date => ben_ext_person.g_benefits_ext_dt,
3542: p_assignment_id => l_asg.assignment_id,
3543: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3566: l_rslt_elmt := l_outputs(l_outputs.first).value;
3567: --
3568: elsif l_rule_type.formula_type_id = -536 then -- Eligible Level Rule
3569: -- Call formula initialise routine
3570: l_outputs := benutils.formula
3571: (p_formula_id => p_data_elmt_rl,
3572: p_effective_date => ben_ext_person.g_benefits_ext_dt,
3573: p_assignment_id => l_asg.assignment_id,
3574: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3588: --
3589: elsif l_rule_type.formula_type_id = -537 then -- Premium Level Rule
3590: hr_utility.set_location(' Rule537:'||l_proc, 35);
3591: -- Call formula initialise routine
3592: l_outputs := benutils.formula
3593: (p_formula_id => p_data_elmt_rl,
3594: p_effective_date => ben_ext_person.g_benefits_ext_dt,
3595: p_assignment_id => l_asg.assignment_id,
3596: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3611: l_rslt_elmt := l_outputs(l_outputs.first).value;
3612: --
3613: elsif l_rule_type.formula_type_id = -538 then -- Dependnt Level Rule
3614: -- Call formula initialise routine
3615: l_outputs := benutils.formula
3616: (p_formula_id => p_data_elmt_rl,
3617: p_effective_date => ben_ext_person.g_benefits_ext_dt,
3618: p_assignment_id => l_asg.assignment_id,
3619: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3632: l_rslt_elmt := l_outputs(l_outputs.first).value;
3633: --
3634: elsif l_rule_type.formula_type_id = -539 then -- Action Item Level Rule
3635: -- Call formula initialise routine
3636: l_outputs := benutils.formula
3637: (p_formula_id => p_data_elmt_rl,
3638: p_effective_date => ben_ext_person.g_benefits_ext_dt,
3639: p_assignment_id => l_asg.assignment_id,
3640: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3652: l_rslt_elmt := l_outputs(l_outputs.first).value;
3653: --
3654: elsif l_rule_type.formula_type_id = -540 then -- Beneficiary level Rule
3655: -- Call formula initialise routine
3656: l_outputs := benutils.formula
3657: (p_formula_id => p_data_elmt_rl,
3658: p_effective_date => ben_ext_person.g_benefits_ext_dt,
3659: p_assignment_id => l_asg.assignment_id,
3660: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3673: l_rslt_elmt := l_outputs(l_outputs.first).value;
3674: --
3675: elsif l_rule_type.formula_type_id = -541 then -- Flex credit level Rule
3676: -- Call formula initialise routine
3677: l_outputs := benutils.formula
3678: (p_formula_id => p_data_elmt_rl,
3679: p_effective_date => ben_ext_person.g_benefits_ext_dt,
3680: p_assignment_id => l_asg.assignment_id,
3681: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3695: l_rslt_elmt := l_outputs(l_outputs.first).value;
3696: --
3697: elsif l_rule_type.formula_type_id = -542 then -- payroll level Rule
3698: -- Call formula initialise routine
3699: l_outputs := benutils.formula
3700: (p_formula_id => p_data_elmt_rl,
3701: p_effective_date => ben_ext_person.g_benefits_ext_dt,
3702: p_assignment_id => l_asg.assignment_id,
3703: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3717: l_rslt_elmt := l_outputs(l_outputs.first).value;
3718: --
3719: elsif l_rule_type.formula_type_id = -543 then -- runresult level Rule
3720: -- Call formula initialise routine
3721: l_outputs := benutils.formula
3722: (p_formula_id => p_data_elmt_rl,
3723: p_effective_date => ben_ext_person.g_benefits_ext_dt,
3724: p_assignment_id => l_asg.assignment_id,
3725: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3744: l_rslt_elmt := l_outputs(l_outputs.first).value;
3745: --
3746: elsif l_rule_type.formula_type_id = -544 then -- contact level Rule
3747: -- Call formula initialise routine
3748: l_outputs := benutils.formula
3749: (p_formula_id => p_data_elmt_rl,
3750: p_effective_date => ben_ext_person.g_benefits_ext_dt,
3751: p_assignment_id => l_asg.assignment_id,
3752: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3766: l_rslt_elmt := l_outputs(l_outputs.first).value;
3767: --
3768: elsif l_rule_type.formula_type_id = -545 then -- elig dpnt level Rule
3769: -- Call formula initialise routine
3770: l_outputs := benutils.formula
3771: (p_formula_id => p_data_elmt_rl,
3772: p_effective_date => ben_ext_person.g_benefits_ext_dt,
3773: p_assignment_id => l_asg.assignment_id,
3774: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id),
3787: --
3788: l_rslt_elmt := l_outputs(l_outputs.first).value;
3789:
3790: elsif l_rule_type.formula_type_id = -546 then -- subheader level rule
3791: l_outputs := benutils.formula
3792: (p_formula_id => p_data_elmt_rl,
3793: p_effective_date => p_effective_date ,
3794: p_business_group_id => nvl(p_ext_per_bg_id,p_business_group_id)
3795: ,p_param1 => 'EXT_DFN_ID'