[Home] [Help]
8941: l_ff_use_asg_id_flag varchar2(1);
8942: l_vrfy_fmly_mmbr_cd varchar2(30);
8943: l_vrfy_fmly_mmbr_rl number;
8944: l_pl_id number;
8945: l_env ben_env_object.g_global_env_rec_type;
8946: --
8947: l_age_val number;
8948: l_los_val number;
8949: l_comb_age number;
9102: where FORMULA_ID = cv_formula_id
9103: and ITEM_NAME = 'ASSIGNMENT_ID'
9104: and usage = 'U';
9105: -- 4958846
9106: l_env_rec ben_env_object.g_global_env_rec_type;
9107: l_benmngle_parm_rec benutils.g_batch_param_rec;
9108: -- Procedure to assign overridden values
9109: --
9110: procedure assign_overriden_values
9362: -- Filter out non CAGR profiles in collective agreement mode
9363: --
9364: -- Get the environment details
9365: --
9366: ben_env_object.get(p_rec => l_env);
9367: --
9368: if l_env.mode_cd = 'A'
9369: and l_eligprof_dets.count > 0 then
9370: --
9537: --
9538: -- Applicant assignment only
9539: --
9540: -- Bug 6509099
9541: ben_env_object.get(p_rec => l_env_rec);
9542: benutils.get_batch_parameters(p_benefit_action_id => l_env_rec.benefit_action_id
9543: ,p_rec => l_benmngle_parm_rec);
9544:
9545: if l_benmngle_parm_rec.mode_cd = 'I' then
9571: -- First assignment only
9572: --
9573: hr_utility.set_location('Getting all assignments',10);
9574: -- 4958846 ssarkar for irec
9575: ben_env_object.get(p_rec => l_env_rec);
9576: benutils.get_batch_parameters(p_benefit_action_id => l_env_rec.benefit_action_id
9577: ,p_rec => l_benmngle_parm_rec);
9578:
9579: hr_utility.set_location('l_benmngle_parm_rec.mode_cd :' || l_benmngle_parm_rec.mode_cd,99);
9660: --
9661: -- Applicant assignment only
9662: --
9663: -- Bug 6509099
9664: ben_env_object.get(p_rec => l_env_rec);
9665: benutils.get_batch_parameters(p_benefit_action_id => l_env_rec.benefit_action_id
9666: ,p_rec => l_benmngle_parm_rec);
9667:
9668: if l_benmngle_parm_rec.mode_cd = 'I' then