DBA Data[Home] [Help]

APPS.AMS_DMPERFORMANCE_PUB dependencies on DUAL

Line 563: FROM dual;

559: l_dummy NUMBER;
560:
561: CURSOR c_perf_id IS
562: SELECT ams_dm_performance_s.NEXTVAL
563: FROM dual;
564:
565: CURSOR c_id_exists (p_performance_id IN NUMBER) IS
566: SELECT 1
567: FROM dual

Line 567: FROM dual

563: FROM dual;
564:
565: CURSOR c_id_exists (p_performance_id IN NUMBER) IS
566: SELECT 1
567: FROM dual
568: WHERE EXISTS (SELECT 1
569: FROM ams_dm_performance
570: WHERE performance_id = p_performance_id)
571: ;