DBA Data[Home] [Help]

APPS.HRI_APL_DGNSTC_OPEN_ENRT dependencies on BEN_PL_DPNT_CVG_CTFN_F

Line 398: FROM ben_pl_dpnt_cvg_ctfn_f pnd

394: OR pln.dpnt_adrs_rqd_flag = 'Y' /* Dependent Requires Address */
395: OR ( pln.dpnt_no_ctfn_rqd_flag = 'N' /* Dependent Requires Certification */
396: AND EXISTS (
397: SELECT 1
398: FROM ben_pl_dpnt_cvg_ctfn_f pnd
399: WHERE pnd.pl_id = pln.pl_id
400: AND cv_end_date
401: BETWEEN pnd.effective_start_date
402: AND pnd.effective_end_date)