APPS.OKC_XPRT_IMPORT_PVT dependencies on OKC_XPRT_RULE_OUTCOMES_ACTIVE

Line 1490: DELETE FROM okc_xprt_rule_outcomes_active WHERE rule_id = l_rule_id;

1486: last_update_login = FND_GLOBAL.LOGIN_ID,
1487: activation_date = SYSDATE
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;

Line 2274: DELETE FROM okc_xprt_rule_outcomes_active WHERE rule_id = l_rule_id;

2270: last_update_date = SYSDATE,
2271: last_update_login = FND_GLOBAL.LOGIN_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;