DBA Data[Home] [Help]

APPS.BEN_EXT_DPNT dependencies on HR_API

Line 209: and nvl(r.date_end,hr_api.g_eot)

205: and a.primary_flag = 'Y'
206: and r.rltd_per_rsds_w_dsgntr_flag = 'Y'
207: /* Start of Changes for WWBUG: 1856611: addition */
208: and p_effective_date between r.date_start
209: and nvl(r.date_end,hr_api.g_eot)
210: /* End of Changes for WWBUG: 1856611: addition */
211: ;
212: --
213: cursor ext_phone_c(p_dpnt_person_id number) is