DBA Data[Home] [Help]

APPS.BEN_DETERMINE_COVERAGE dependencies on BEN_LER_BNFT_RSTRN_F

Line 1643: from ben_ler_bnft_rstrn_f rstrn

1639: rstrn.no_mn_cvg_incr_apls_flag no_mn_cvg_amt_apls_flag,
1640: rstrn.no_mx_cvg_amt_apls_flag no_mx_cvg_amt_apls_flag,
1641: rstrn.dflt_to_asn_pndg_ctfn_cd, /*ENH*/
1642: rstrn.dflt_to_asn_pndg_ctfn_rl -- 5529258
1643: from ben_ler_bnft_rstrn_f rstrn
1644: where rstrn.ler_id = l_ler_id
1645: and rstrn.pl_id = l_pl_id
1646: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
1647: between rstrn.effective_start_date

Line 1681: from ben_ler_bnft_rstrn_ctfn_f ctfn, ben_ler_bnft_rstrn_f lbr -- Bug 5887665

1677: select ctfn.rqd_flag,
1678: ctfn.enrt_ctfn_typ_cd,
1679: ctfn.ctfn_rqd_when_rl,
1680: lbr.ctfn_determine_cd
1681: from ben_ler_bnft_rstrn_ctfn_f ctfn, ben_ler_bnft_rstrn_f lbr -- Bug 5887665
1682: where ctfn.ler_bnft_rstrn_id = l_ler_bnft_rstrn_id
1683: and ctfn.ler_bnft_rstrn_id = lbr.ler_bnft_rstrn_id
1684: and ctfn.business_group_id = l_business_group_id
1685: and lbr.business_group_id = l_business_group_id