APPS.AMS_LISTSOURCETYPE_PVT dependencies on DUAL

Line 118: FROM dual;

114: l_dummy NUMBER; -- Capture the exit condition for ID existence loop.
115:
116: CURSOR c_seq IS
117: SELECT ams_list_src_types_s.NEXTVAL
118: FROM dual;
119:
120: CURSOR c_id_exists (x_id IN NUMBER) IS
121: SELECT 1
122: FROM ams_list_src_types

Line 1036: FROM DUAL;

1032: cursor c_viewname(code in varchar2) is
1033: SELECT length(nvl(TRANSLATE(code,
1034: '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_',
1035: ' '), 0))
1036: FROM DUAL;
1037: l_cnt NUMBER := 1;
1038:
1039: BEGIN
1040: