DBA Data[Home] [Help]

APPS.CZ_PB_USG dependencies on CZ_RULES

Line 185: FROM cz_rules

181: BULK
182: COLLECT
183: INTO v_rules,
184: v_masks_rules
185: FROM cz_rules
186: WHERE effective_usage_mask NOT IN ('0', '0000000000000000')
187: ORDER BY effective_usage_mask;
188: EXCEPTION
189: WHEN OTHERS THEN

Line 249: UPDATE cz_rules

245: END IF;
246: END LOOP;
247:
248: FORALL i IN v_rules.FIRST..v_rules.LAST
249: UPDATE cz_rules
250: SET effective_usage_mask = v_masks_rules(i)
251: WHERE rule_id = v_rules(i);
252: END IF;
253: EXCEPTION