DBA Data[Home] [Help]

APPS.AMS_PARTYIMPORT_PVT dependencies on DUAL

Line 106: FROM dual;

102: l_dummy NUMBER; -- Capture the exit condition for ID existence loop.
103:
104: CURSOR c_seq IS
105: SELECT ams_party_sources_s.NEXTVAL
106: FROM dual;
107:
108: CURSOR c_id_exists (x_id IN NUMBER) IS
109: SELECT 1
110: FROM dual

Line 110: FROM dual

106: FROM dual;
107:
108: CURSOR c_id_exists (x_id IN NUMBER) IS
109: SELECT 1
110: FROM dual
111: WHERE EXISTS (SELECT 1
112: FROM ams_party_sources
113: WHERE party_sources_id = x_id);
114: BEGIN