APPS.OTA_LO_UTILITY dependencies on DUAL

Line 471: into l_test_id from dual;

467: fetch csr_evt_evaluations into l_evt_eval_id,l_eval_mand_flag,l_act_eval_id;
468: close csr_evt_evaluations;
469: if(l_eval_mand_flag = 'Y') then
470: select decode(l_evt_eval_id,l_act_eval_id,null,nvl(l_evt_eval_id,l_act_eval_id))
471: into l_test_id from dual;
472: open csr_attempt_info;
473: fetch csr_attempt_info into l_dummy;
474: if csr_attempt_info%found Then
475: l_is_attempted := true;

Line 511: into l_test_id from dual;

507: fetch csr_evt_evaluations into l_evt_eval_id,l_eval_mand_flag,l_act_eval_id;
508: close csr_evt_evaluations;
509: if(l_eval_mand_flag = 'Y') then
510: select decode(l_evt_eval_id,l_act_eval_id,null,nvl(l_evt_eval_id,l_act_eval_id))
511: into l_test_id from dual;
512: open csr_attempt_info;
513: fetch csr_attempt_info into l_dummy;
514: if csr_attempt_info%found Then
515: l_is_attempted := true;