DBA Data[Home] [Help]

APPS.AST_GRP_CAMP_PVT dependencies on DUAL

Line 810: FROM DUAL;

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

Line 813: FROM DUAL;

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