APPS.HRI_APL_DGNSTC_OPEN_ENRT dependencies on BEN_PL_BNF_CTFN_F

Line 332: FROM ben_pl_bnf_ctfn_f pcx

328: OR pln.bnf_dsge_mnr_ttee_rqd_flag = 'Y'/* Beneficiary requires a Trustee */
329: OR ( pln.bnf_ctfn_rqd_flag = 'N' /* Beneficiary Requires Certification */
330: AND EXISTS (
331: SELECT 1
332: FROM ben_pl_bnf_ctfn_f pcx
333: WHERE pcx.pl_id = pln.pl_id
334: AND cv_end_date BETWEEN pcx.effective_start_date
335: AND pcx.effective_end_date)
336: )