DBA Data[Home] [Help]

APPS.BEN_DETERMINE_CHC_CTFN dependencies on BEN_LER_BNFT_RSTRN_F

Line 377: from ben_ler_bnft_rstrn_f rstrn,

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

Line 396: ben_ler_bnft_rstrn_f lbr

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