APPS.OKC_XPRT_IMPORT_PVT dependencies on OKC_XPRT_RULE_CONDITIONS

Line 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);

1488: WHERE rule_id = l_rule_id;
1489:
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;

Line 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);

2272: WHERE rule_id = l_rule_id;
2273:
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;