DBA Data[Home] [Help]

APPS.BEN_PTNL_LER_FOR_PER_API dependencies on BEN_ELIG_OBJ_F

Line 99: (select obj.ELIG_OBJ_ID from ben_elig_obj_f obj ,

95:
96: --
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