APPS.AMS_CAT_ACTIVITY_PVT dependencies on DUAL

Line 54: FROM dual;

50: l_dummy NUMBER;
51:
52: CURSOR c_id IS
53: SELECT AMS_CAT_ACTIVITIES_s.NEXTVAL
54: FROM dual;
55:
56: CURSOR c_id_exists (l_id IN NUMBER) IS
57: SELECT 1 FROM dual
58: WHERE EXISTS (SELECT 1 FROM AMS_CAT_ACTIVITIES

Line 57: SELECT 1 FROM dual

53: SELECT AMS_CAT_ACTIVITIES_s.NEXTVAL
54: FROM dual;
55:
56: CURSOR c_id_exists (l_id IN NUMBER) IS
57: SELECT 1 FROM dual
58: WHERE EXISTS (SELECT 1 FROM AMS_CAT_ACTIVITIES
59: WHERE CAT_ACTIVITY_ID = l_id);
60:
61: BEGIN