APPS.CSP_PACK_SERIAL_LOTS_PVT dependencies on DUAL

Line 834: FROM DUAL;

830: -- cursors to check if wildcard values '%' and '_' have been passed
831: -- as item values
832: CURSOR c_chk_str1(p_rec_item VARCHAR2) IS
833: SELECT INSTR(p_rec_item, '%', 1, 1)
834: FROM DUAL;
835: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
836: SELECT INSTR(p_rec_item, '_', 1, 1)
837: FROM DUAL;
838:

Line 837: FROM DUAL;

833: SELECT INSTR(p_rec_item, '%', 1, 1)
834: FROM DUAL;
835: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
836: SELECT INSTR(p_rec_item, '_', 1, 1)
837: FROM DUAL;
838:
839: -- return values from cursors
840: str_csr1 NUMBER;
841: str_csr2 NUMBER;