DBA Data[Home] [Help]

APPS.BEN_DETERMINE_DATE dependencies on BEN_ELIG_CVRD_DPNT_F

Line 972: from ben_elig_cvrd_dpnt_f ecd

968: --
969: cursor c_elig_cvg_dpnt_dts is
970: select ecd.cvg_thru_dt,
971: ecd.effective_end_date
972: from ben_elig_cvrd_dpnt_f ecd
973: where ecd.per_in_ler_id = l_per_in_ler_id
974: and ecd.business_group_id = l_business_group_id
975: and nvl(l_lf_evt_ocrd_dt,p_effective_date)
976: between ecd.effective_start_date

Line 1053: from ben_elig_cvrd_dpnt_f ecd

1049:
1050: cursor c_elig_dpnt_dts is
1051: select ecd.cvg_strt_dt,
1052: ecd.cvg_thru_dt
1053: from ben_elig_cvrd_dpnt_f ecd
1054: where ecd.per_in_ler_id = l_per_in_ler_id
1055: and ecd.business_group_id = l_business_group_id
1056: and nvl(l_lf_evt_ocrd_dt,p_effective_date)
1057: between ecd.effective_start_date