APPS.BEN_DETERMINE_COMMUNICATIONS1 dependencies on HR_API

Line 137: and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot

133: )
134: and pen.sspndd_flag = 'N'
135: and pen.prtt_enrt_rslt_stat_cd is null
136: and pen.business_group_id = c_bgp_id
137: and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
138: and c_effdt
139: between pen.effective_start_date and pen.effective_end_date
140: and pen.effective_end_date = hr_api.g_eot
141: )

Line 140: and pen.effective_end_date = hr_api.g_eot

136: and pen.business_group_id = c_bgp_id
137: and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
138: and c_effdt
139: between pen.effective_start_date and pen.effective_end_date
140: and pen.effective_end_date = hr_api.g_eot
141: )
142: )
143: or
144: (c_elig_enrol_cd is null)

Line 305: and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot

301: )
302: and pen.sspndd_flag = 'N'
303: and pen.prtt_enrt_rslt_stat_cd is null
304: and pen.business_group_id = c_bgp_id
305: and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
306: and c_effdt
307: between pen.effective_start_date and pen.effective_end_date
308: and pen.effective_end_date = hr_api.g_eot
309: )

Line 308: and pen.effective_end_date = hr_api.g_eot

304: and pen.business_group_id = c_bgp_id
305: and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
306: and c_effdt
307: between pen.effective_start_date and pen.effective_end_date
308: and pen.effective_end_date = hr_api.g_eot
309: )
310: )
311: or
312: (c_elig_enrol_cd is null)