APPS.CSP_RS_CUST_RELATION_PVT dependencies on DUAL

Line 811: FROM DUAL;

807: -- cursors to check if wildcard values '%' and '_' have been passed
808: -- as item values
809: CURSOR c_chk_str1(p_rec_item VARCHAR2) IS
810: SELECT INSTR(p_rec_item, '%', 1, 1)
811: FROM DUAL;
812: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
813: SELECT INSTR(p_rec_item, '_', 1, 1)
814: FROM DUAL;
815:

Line 814: FROM DUAL;

810: SELECT INSTR(p_rec_item, '%', 1, 1)
811: FROM DUAL;
812: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
813: SELECT INSTR(p_rec_item, '_', 1, 1)
814: FROM DUAL;
815:
816: -- return values from cursors
817: str_csr1 NUMBER;
818: str_csr2 NUMBER;