APPS.BEN_PTNL_LER_FOR_PER_API dependencies on DUAL

Line 98: select '1' from dual where exists

94: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;
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

Line 438: from sys.dual;

434: l_object_version_number := 1;
435: --
436: select ben_ptnl_ler_for_per_s.nextval
437: into l_ptnl_ler_for_per_id
438: from sys.dual;
439: --
440: insert into ben_ptnl_ler_for_per
441: (ptnl_ler_for_per_id
442: ,csd_by_ptnl_ler_for_per_id