DBA Data[Home] [Help]

APPS.BEN_EVALUATE_RATE_PROFILES dependencies on BEN_LER_F

Line 3849: , ben_ler_f ler

3845: --
3846: cursor c_get_dsblity_evt(p_cbr_quald_bnf_id number) is
3847: select null
3848: from ben_cbr_per_in_ler crp
3849: , ben_ler_f ler
3850: , ben_per_in_ler pil
3851: where crp.cbr_quald_bnf_id = p_cbr_quald_bnf_id
3852: and crp.per_in_ler_id = pil.per_in_ler_id
3853: and pil.ler_id = ler.ler_id

Line 3874: from ben_ler_f ler

3870: --
3871: cursor c_get_arra_evt(p_cbr_elig_perd_strt_dt date
3872: ,p_cbr_elig_perd_end_dt date) is
3873: select null
3874: from ben_ler_f ler
3875: , ben_per_in_ler pil
3876: where ler.ler_id = pil.ler_id
3877: and pil.person_id = p_person_id
3878: and ler.name = 'Assistance Eligible Individual'

Line 3893: ben_ler_f ler

3889: --
3890: cursor c_ler is
3891: select ler.*
3892: from
3893: ben_ler_f ler
3894: where
3895: ler.ler_id = p_ler_id
3896: and ler.QUALG_EVT_FLAG = 'Y'
3897: and p_effective_date between