DBA Data[Home] [Help]

APPS.BEN_DETERMINE_DATE dependencies on BEN_ELIG_CVRD_DPNT_F

Line 974: from ben_elig_cvrd_dpnt_f ecd

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

Line 1055: from ben_elig_cvrd_dpnt_f ecd

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