[Home] [Help]
3093: ,abr.element_type_id
3094: ,prv.element_entry_value_id
3095: ,pev.effective_end_date
3096: ,pee.element_link_id
3097: from ben_prtt_rt_val prv,
3098: ben_acty_base_rt_f abr,
3099: pay_element_entry_values_f pev,
3100: pay_element_entries_f pee
3101: where prv.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
3190: prv.rt_end_dt,
3191: prv.rt_val,
3192: prv.ann_rt_val,
3193: prv.acty_ref_perd_cd
3194: from ben_prtt_rt_val prv
3195: where prv.prtt_rt_val_stat_cd is null
3196: and prv.prtt_enrt_rslt_id = p_pen_id
3197: and prv.per_in_ler_id = cp_per_in_ler_id
3198: and prv.rt_strt_dt = -- for Unrestricted
3196: and prv.prtt_enrt_rslt_id = p_pen_id
3197: and prv.per_in_ler_id = cp_per_in_ler_id
3198: and prv.rt_strt_dt = -- for Unrestricted
3199: (select max(prv1.rt_strt_dt)
3200: from ben_prtt_rt_val prv1
3201: where prv1.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
3202: and prv1.per_in_ler_id = prv.per_in_ler_id
3203: and prv1.prtt_rt_val_stat_cd is null
3204: and prv1.acty_base_rt_id = prv.acty_base_rt_id);
3205: l_prv_sspndd c_prv_sspndd%rowtype;
3206:
3207: cursor c_prv_rowid (p_rowid rowid) is
3208: select object_version_number
3209: from ben_prtt_rt_val
3210: where rowid = p_rowid;
3211:
3212: cursor c_prv (p_prtt_enrt_rslt_id number,
3213: p_per_in_ler_id number) is
3217: prv.rt_strt_dt,
3218: prv.per_in_ler_id,
3219: prv.prtt_enrt_rslt_id,
3220: pil.person_id
3221: from ben_prtt_rt_val prv,
3222: ben_per_in_ler pil
3223: where prv.per_in_ler_id = p_per_in_ler_id
3224: and prv.per_in_ler_id = pil.per_in_ler_id
3225: and prv.prtt_rt_val_stat_cd is null
3225: and prv.prtt_rt_val_stat_cd is null
3226: and prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3227: and prv.rt_end_dt <> hr_api.g_eot
3228: and prv.rt_strt_dt = (select max(rt_strt_dt)
3229: from ben_prtt_rt_val
3230: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3231: and rt_end_dt <> hr_api.g_eot
3232: and prtt_rt_val_stat_cd is null)
3233: ;
3483: open c_prv_rowid(l_prv_sspndd.rowid);
3484: fetch c_prv_rowid into l_prv_sspndd.object_version_number;
3485: close c_prv_rowid;
3486:
3487: ben_prtt_rt_val_api.update_prtt_rt_val
3488: (p_validate => false
3489: ,p_business_group_id => p_business_group_id
3490: ,p_prtt_rt_val_id => l_prv_sspndd.prtt_rt_val_id
3491: ,p_element_entry_value_id => null
3572: fetch c_prv into l_prv;
3573: if c_prv%notfound then
3574: exit;
3575: end if;
3576: ben_prtt_rt_val_api.update_prtt_rt_val
3577: (p_validate => FALSE
3578: ,p_prtt_rt_val_id => l_prv.prtt_rt_val_id
3579: ,p_object_version_number => l_prv.object_version_number
3580: ,p_rt_end_dt => hr_api.g_eot
3821: cursor c_prv (c_prtt_enrt_rslt_id number) is
3822: select prv.*
3823: ,abr.input_value_id
3824: ,abr.element_type_id
3825: from ben_prtt_rt_val prv,
3826: ben_acty_base_rt_f abr
3827: where prv.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
3828: and prv.per_in_ler_id = l_per_in_ler_id
3829: and prv.rt_strt_dt <= prv.rt_end_dt
4284: -- We need to end the rates one day before the new Coverage start as per
4285: -- Unsuspend Code which is l_cvg_thru_dt
4286: For l_prv in c_prv (l_interim.prtt_enrt_rslt_id) loop
4287: l_last_place := 'Calling update_prtt_rt_val';
4288: ben_prtt_rt_val_api.update_prtt_rt_val
4289: (P_VALIDATE => FALSE
4290: ,P_PRTT_RT_VAL_ID => l_prv.prtt_rt_val_id
4291: ,p_person_id => l_interim.person_id
4292: ,P_RT_END_DT => l_cvg_thru_dt -- 999 l_rec_rt_end_dt
4506: -- has started on a date earlier than effective_date / date of un-suspension.
4507: -- if (l_rec_rt_strt_dt<>l_prv.rt_strt_dt) and
4508: if (l_rec_rt_strt_dt > l_prv.rt_strt_dt) and
4509: l_update_dates then
4510: ben_prtt_rt_val_api.update_prtt_rt_val
4511: (P_VALIDATE => FALSE
4512: ,P_PRTT_RT_VAL_ID => l_prv.prtt_rt_val_id
4513: ,p_person_id => l_pen.person_id
4514: ,P_RT_STRT_DT => l_rec_rt_strt_dt