APPS.CSP_PACKLIST_LINES_PVT dependencies on DUAL

Line 960: FROM DUAL;

956: -- cursors to check if wildcard values '%' and '_' have been passed
957: -- as item values
958: CURSOR c_chk_str1(p_rec_item VARCHAR2) IS
959: SELECT INSTR(p_rec_item, '%', 1, 1)
960: FROM DUAL;
961: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
962: SELECT INSTR(p_rec_item, '_', 1, 1)
963: FROM DUAL;
964:

Line 963: FROM DUAL;

959: SELECT INSTR(p_rec_item, '%', 1, 1)
960: FROM DUAL;
961: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
962: SELECT INSTR(p_rec_item, '_', 1, 1)
963: FROM DUAL;
964:
965: -- return values from cursors
966: str_csr1 NUMBER;
967: str_csr2 NUMBER;