APPS.BEN_EVALUATE_PTNL_LF_EVT dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 3605: cursor c_ben_pil_elctbl_chc_popl (p_per_in_ler_id number) is

3601: between ler.effective_start_date
3602: and ler.effective_end_date
3603: and ler.typ_cd = 'IREC';
3604: --
3605: cursor c_ben_pil_elctbl_chc_popl (p_per_in_ler_id number) is
3606: select pel.pil_elctbl_chc_popl_id,
3607: pel.object_version_number
3608: from ben_pil_elctbl_chc_popl pel,
3609: ben_per_in_ler pil

Line 3608: from ben_pil_elctbl_chc_popl pel,

3604: --
3605: cursor c_ben_pil_elctbl_chc_popl (p_per_in_ler_id number) is
3606: select pel.pil_elctbl_chc_popl_id,
3607: pel.object_version_number
3608: from ben_pil_elctbl_chc_popl pel,
3609: ben_per_in_ler pil
3610: where pil.per_in_ler_id = p_per_in_ler_id
3611: and pil.business_group_id = p_business_group_id
3612: and pel.per_in_ler_id = pil.per_in_ler_id

Line 3724: open c_ben_pil_elctbl_chc_popl(l_pil_rec.per_in_ler_id) ;

3720: ,P_STRTD_DT => l_strtd_dt
3721: ,P_VOIDD_DT => l_voidd_dt );
3722:
3723: -- update PEL
3724: open c_ben_pil_elctbl_chc_popl(l_pil_rec.per_in_ler_id) ;
3725:
3726: loop
3727:
3728: fetch c_ben_pil_elctbl_chc_popl into l_pel_pk_id,

Line 3728: fetch c_ben_pil_elctbl_chc_popl into l_pel_pk_id,

3724: open c_ben_pil_elctbl_chc_popl(l_pil_rec.per_in_ler_id) ;
3725:
3726: loop
3727:
3728: fetch c_ben_pil_elctbl_chc_popl into l_pel_pk_id,
3729: l_pel_object_version_number;
3730: exit when c_ben_pil_elctbl_chc_popl%notfound;
3731: --
3732: --

Line 3730: exit when c_ben_pil_elctbl_chc_popl%notfound;

3726: loop
3727:
3728: fetch c_ben_pil_elctbl_chc_popl into l_pel_pk_id,
3729: l_pel_object_version_number;
3730: exit when c_ben_pil_elctbl_chc_popl%notfound;
3731: --
3732: --
3733: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl
3734: (p_validate => false,

Line 3733: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl

3729: l_pel_object_version_number;
3730: exit when c_ben_pil_elctbl_chc_popl%notfound;
3731: --
3732: --
3733: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl
3734: (p_validate => false,
3735: p_pil_elctbl_chc_popl_id => l_pel_pk_id,
3736: p_pil_elctbl_popl_stat_cd => 'BCKDT',
3737: p_object_version_number => l_pel_object_version_number,

Line 3742: close c_ben_pil_elctbl_chc_popl;

3738: p_effective_date => p_effective_date);
3739:
3740: end loop;
3741:
3742: close c_ben_pil_elctbl_chc_popl;
3743:
3744: -- update PPL
3745: --
3746: -- If lf event occured date is different then update the life event