DBA Data[Home] [Help]

APPS.AMS_SCORERESULT_PUB dependencies on DUAL

Line 539: FROM dual;

535: l_dummy NUMBER;
536:
537: CURSOR c_result_id IS
538: SELECT ams_dm_score_results_s.NEXTVAL
539: FROM dual;
540:
541: CURSOR c_id_exists (p_result_id IN NUMBER) IS
542: SELECT 1
543: FROM dual

Line 543: FROM dual

539: FROM dual;
540:
541: CURSOR c_id_exists (p_result_id IN NUMBER) IS
542: SELECT 1
543: FROM dual
544: WHERE EXISTS (SELECT 1
545: FROM ams_dm_score_results
546: WHERE score_result_id = p_result_id)
547: ;