APPS.CSP_PRODUCT_TASK_PVT dependencies on DUAL

Line 591: FROM DUAL;

587: -- cursors to check if wildcard values '%' and '_' have been passed
588: -- as item values
589: CURSOR c_chk_str1(p_rec_item VARCHAR2) IS
590: SELECT INSTR(p_rec_item, '%', 1, 1)
591: FROM DUAL;
592: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
593: SELECT INSTR(p_rec_item, '_', 1, 1)
594: FROM DUAL;
595: -- return values from cursors

Line 594: FROM DUAL;

590: SELECT INSTR(p_rec_item, '%', 1, 1)
591: FROM DUAL;
592: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
593: SELECT INSTR(p_rec_item, '_', 1, 1)
594: FROM DUAL;
595: -- return values from cursors
596: str_csr1 NUMBER;
597: str_csr2 NUMBER;
598: l_operator VARCHAR2(10);