APPS.AMS_CNT_POINT_PVT dependencies on DUAL

Line 56: FROM dual;

52: l_dummy NUMBER;
53:
54: CURSOR c_id IS
55: SELECT AMS_ACT_CONTACT_POINTS_s.NEXTVAL
56: FROM dual;
57:
58: CURSOR c_id_exists (l_id IN NUMBER) IS
59: SELECT 1 FROM dual
60: WHERE EXISTS (SELECT 1 FROM AMS_ACT_CONTACT_POINTS

Line 59: SELECT 1 FROM dual

55: SELECT AMS_ACT_CONTACT_POINTS_s.NEXTVAL
56: FROM dual;
57:
58: CURSOR c_id_exists (l_id IN NUMBER) IS
59: SELECT 1 FROM dual
60: WHERE EXISTS (SELECT 1 FROM AMS_ACT_CONTACT_POINTS
61: WHERE CONTACT_POINT_ID = l_id);
62:
63: BEGIN