[Home] [Help]
11: CURSOR C1 IS
12: SELECT 1
13: FROM dual
14: WHERE EXISTS (SELECT 1
15: FROM OE_DEF_ATTR_CONDNS
16: WHERE CONDITION_ID = p_condition_id);
17: CURSOR C2 IS
18: SELECT 1
19: FROM dual
294:
295: DELETE FROM OE_DEF_ATTR_DEF_RULES
296: WHERE attr_def_condition_id = l_condition_id;
297:
298: DELETE FROM OE_DEF_ATTR_CONDNS
299: WHERE condition_id = l_condition_id;
300:
301: end if;
302: