APPS.AD_PATCH_ANALYSIS_ENGINE dependencies on DUAL

Line 259: SELECT GREATEST(l_value_1, l_value_2) INTO l_tmpVar FROM DUAL;

255: WHEN (TO_NUMBER(l_value_1) < TO_NUMBER(l_value_2) ) THEN RETURN 2;
256: END CASE;
257: EXCEPTION
258: WHEN VALUE_ERROR THEN
259: SELECT GREATEST(l_value_1, l_value_2) INTO l_tmpVar FROM DUAL;
260: CASE
261: WHEN ((l_tmpVar = l_value_2) AND (l_tmpVar = l_value_1)) THEN NULL;
262: WHEN (l_tmpVar = l_value_1) THEN RETURN 1;
263: WHEN (l_tmpVar = l_value_2) THEN RETURN 2;

Line 394: FROM DUAL

390: p_user_id,
391: sysdate,
392: p_user_id,
393: sysdate
394: FROM DUAL
395: WHERE NOT EXISTS
396: ( SELECT 'x' FROM ad_pa_anal_run_bug_prereqs
397: WHERE analysis_run_bug_id = l_analysis_run_bug_id
398: AND prereq_te_abbr = l_tmpVar

Line 435: FROM DUAL

431: p_user_id,
432: sysdate,
433: p_user_id,
434: sysdate
435: FROM DUAL
436: WHERE NOT EXISTS
437: ( SELECT 'x' FROM ad_pa_anal_run_bug_codelevels
438: WHERE analysis_run_bug_id = l_analysis_run_bug_id
439: AND intr_te_abbr = l_tmpVar

Line 717: -- select ad_patch_analysis_engine.compareLevel('120.22','33') from dual

713: --- exec :p := ad_patch_analysis_engine.getPatchStatus(9000002,'R12','R12', :c);
714: --- exec :p := ad_patch_analysis_engine.getPatchStatus(7000002,'AD.1.0','R12', :c, 4652175, 4);
715: --- exec :p := ad_patch_analysis_engine.getPatchStatus(8000004,'R12','R12', :c);
716: --- exec :p := ad_patch_analysis_engine.compareLevel('AD.1.2','AD.1')
717: -- select ad_patch_analysis_engine.compareLevel('120.22','33') from dual
718:
719: END ad_patch_analysis_engine;