DBA Data[Home] [Help]

APPS.AMS_DMPERFORMANCE_PVT dependencies on DUAL

Line 58: FROM dual;

54: l_dummy NUMBER;
55:
56: CURSOR c_id IS
57: SELECT AMS_DM_PERFORMANCE_s.NEXTVAL
58: FROM dual;
59:
60: CURSOR c_id_exists (l_id IN NUMBER) IS
61: SELECT 1 FROM dual
62: WHERE EXISTS (SELECT 1 FROM AMS_DM_PERFORMANCE

Line 61: SELECT 1 FROM dual

57: SELECT AMS_DM_PERFORMANCE_s.NEXTVAL
58: FROM dual;
59:
60: CURSOR c_id_exists (l_id IN NUMBER) IS
61: SELECT 1 FROM dual
62: WHERE EXISTS (SELECT 1 FROM AMS_DM_PERFORMANCE
63: WHERE PERFORMANCE_ID = l_id);
64:
65: BEGIN