APPS.OKC_XPRT_IMPORT_PVT dependencies on OKC_XPRT_RULE_COND_ACTIVE

Line 1494: DELETE FROM okc_xprt_rule_cond_active WHERE rule_id = l_rule_id;

1490: DELETE FROM okc_xprt_rule_outcomes_active WHERE rule_id = l_rule_id;
1491:
1492: DELETE FROM okc_xprt_rule_cond_vals_active WHERE rule_condition_id IN (SELECT rule_condition_id FROM okc_xprt_rule_conditions WHERE rule_id = l_rule_id);
1493:
1494: DELETE FROM okc_xprt_rule_cond_active WHERE rule_id = l_rule_id;
1495:
1496: DELETE FROM okc_xprt_rule_hdrs_all_active WHERE rule_id = l_rule_id;
1497:
1498: END LOOP;

Line 2278: DELETE FROM okc_xprt_rule_cond_active WHERE rule_id = l_rule_id;

2274: DELETE FROM okc_xprt_rule_outcomes_active WHERE rule_id = l_rule_id;
2275:
2276: DELETE FROM okc_xprt_rule_cond_vals_active WHERE rule_condition_id IN (SELECT rule_condition_id FROM okc_xprt_rule_conditions WHERE rule_id = l_rule_id);
2277:
2278: DELETE FROM okc_xprt_rule_cond_active WHERE rule_id = l_rule_id;
2279:
2280: DELETE FROM okc_xprt_rule_hdrs_all_active WHERE rule_id = l_rule_id;
2281:
2282: END LOOP;