DBA Data[Home] [Help]

APPS.BEN_DETERMINE_COVERAGE dependencies on BEN_LER_BNFT_RSTRN_F

Line 1682: from ben_ler_bnft_rstrn_f rstrn

1678: rstrn.no_mn_cvg_incr_apls_flag no_mn_cvg_amt_apls_flag,
1679: rstrn.no_mx_cvg_amt_apls_flag no_mx_cvg_amt_apls_flag,
1680: rstrn.dflt_to_asn_pndg_ctfn_cd, /*ENH*/
1681: rstrn.dflt_to_asn_pndg_ctfn_rl -- 5529258
1682: from ben_ler_bnft_rstrn_f rstrn
1683: where rstrn.ler_id = l_ler_id
1684: and rstrn.pl_id = l_pl_id
1685: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
1686: between rstrn.effective_start_date

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

1716: select ctfn.rqd_flag,
1717: ctfn.enrt_ctfn_typ_cd,
1718: ctfn.ctfn_rqd_when_rl,
1719: lbr.ctfn_determine_cd
1720: from ben_ler_bnft_rstrn_ctfn_f ctfn, ben_ler_bnft_rstrn_f lbr -- Bug 5887665
1721: where ctfn.ler_bnft_rstrn_id = l_ler_bnft_rstrn_id
1722: and ctfn.ler_bnft_rstrn_id = lbr.ler_bnft_rstrn_id
1723: and ctfn.business_group_id = l_business_group_id
1724: and lbr.business_group_id = l_business_group_id