APPS.BEN_PTNL_LER_FOR_PER_API dependencies on BEN_LER_F

Line 101: ben_ler_f ler

97: cursor c_chk_elig_crit(c_ler_id number,c_effective_date date) is
98: select '1' from dual where exists
99: (select obj.ELIG_OBJ_ID from ben_elig_obj_f obj ,
100: ben_elig_obj_elig_profl_f obe,
101: ben_ler_f ler
102: where c_effective_date between obj.effective_start_date
103: and obj.effective_end_date
104: and c_effective_date between obe.effective_start_date
105: and obe.effective_end_date

Line 106: and obj.table_name = 'BEN_LER_F'

102: where c_effective_date between obj.effective_start_date
103: and obj.effective_end_date
104: and c_effective_date between obe.effective_start_date
105: and obe.effective_end_date
106: and obj.table_name = 'BEN_LER_F'
107: and obj.column_name = 'LER_ID'
108: and obj.column_value = p_ler_id
109: and obj.business_group_id = p_business_group_id
110: and obe.business_group_id = p_business_group_id