APPS.CSP_ORDERLINES_PVT dependencies on DUAL

Line 927: FROM DUAL;

923: -- cursors to check if wildcard values '%' and '_' have been passed
924: -- as item values
925: CURSOR c_chk_str1(p_rec_item VARCHAR2) IS
926: SELECT INSTR(p_rec_item, '%', 1, 1)
927: FROM DUAL;
928: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
929: SELECT INSTR(p_rec_item, '_', 1, 1)
930: FROM DUAL;
931:

Line 930: FROM DUAL;

926: SELECT INSTR(p_rec_item, '%', 1, 1)
927: FROM DUAL;
928: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
929: SELECT INSTR(p_rec_item, '_', 1, 1)
930: FROM DUAL;
931:
932: -- return values from cursors
933: str_csr1 NUMBER;
934: str_csr2 NUMBER;