DBA Data[Home] [Help]

APPS.BEN_DETERMINE_CHC_CTFN dependencies on BEN_LER_BNFT_RSTRN_F

Line 375: from ben_ler_bnft_rstrn_f rstrn,

371: l_rstrn_found boolean := false;
372: --
373: cursor c_ler_rstrn is
374: select rstrn.ler_bnft_rstrn_id
375: from ben_ler_bnft_rstrn_f rstrn,
376: ben_pl_f pln
377: where rstrn.pl_id = p_pl_id
378: and rstrn.ler_id = p_ler_id
379: and rstrn.pl_id = pln.pl_id

Line 394: ben_ler_bnft_rstrn_f lbr

390: ctfn.ctfn_rqd_when_rl,
391: lbr.susp_if_ctfn_not_prvd_flag,
392: lbr.ctfn_determine_cd
393: from ben_ler_bnft_rstrn_ctfn_f ctfn,
394: ben_ler_bnft_rstrn_f lbr
395: where ctfn.ler_bnft_rstrn_id = l_ler_bnft_rstrn_id
396: and lbr.ler_bnft_rstrn_id = ctfn.ler_bnft_rstrn_id
397: and p_effective_date between
398: lbr.effective_start_date and lbr.effective_end_date