[Home] [Help]
8922: l_ff_use_asg_id_flag varchar2(1);
8923: l_vrfy_fmly_mmbr_cd varchar2(30);
8924: l_vrfy_fmly_mmbr_rl number;
8925: l_pl_id number;
8926: l_env ben_env_object.g_global_env_rec_type;
8927: --
8928: l_age_val number;
8929: l_los_val number;
8930: l_comb_age number;
9083: where FORMULA_ID = cv_formula_id
9084: and ITEM_NAME = 'ASSIGNMENT_ID'
9085: and usage = 'U';
9086: -- 4958846
9087: l_env_rec ben_env_object.g_global_env_rec_type;
9088: l_benmngle_parm_rec benutils.g_batch_param_rec;
9089: -- Procedure to assign overridden values
9090: --
9091: procedure assign_overriden_values
9343: -- Filter out non CAGR profiles in collective agreement mode
9344: --
9345: -- Get the environment details
9346: --
9347: ben_env_object.get(p_rec => l_env);
9348: --
9349: if l_env.mode_cd = 'A'
9350: and l_eligprof_dets.count > 0 then
9351: --
9518: --
9519: -- Applicant assignment only
9520: --
9521: -- Bug 6509099
9522: ben_env_object.get(p_rec => l_env_rec);
9523: benutils.get_batch_parameters(p_benefit_action_id => l_env_rec.benefit_action_id
9524: ,p_rec => l_benmngle_parm_rec);
9525:
9526: if l_benmngle_parm_rec.mode_cd = 'I' then
9552: -- First assignment only
9553: --
9554: hr_utility.set_location('Getting all assignments',10);
9555: -- 4958846 ssarkar for irec
9556: ben_env_object.get(p_rec => l_env_rec);
9557: benutils.get_batch_parameters(p_benefit_action_id => l_env_rec.benefit_action_id
9558: ,p_rec => l_benmngle_parm_rec);
9559:
9560: hr_utility.set_location('l_benmngle_parm_rec.mode_cd :' || l_benmngle_parm_rec.mode_cd,99);
9641: --
9642: -- Applicant assignment only
9643: --
9644: -- Bug 6509099
9645: ben_env_object.get(p_rec => l_env_rec);
9646: benutils.get_batch_parameters(p_benefit_action_id => l_env_rec.benefit_action_id
9647: ,p_rec => l_benmngle_parm_rec);
9648:
9649: if l_benmngle_parm_rec.mode_cd = 'I' then