APPS.OKC_XPRT_IMPORT_PVT dependencies on OKC_XPRT_RULE_HDRS_ALL_ACTIVE

Line 1496: DELETE FROM okc_xprt_rule_hdrs_all_active WHERE rule_id = l_rule_id;

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;
1499: CLOSE csr_rules;
1500:

Line 2280: DELETE FROM okc_xprt_rule_hdrs_all_active WHERE rule_id = l_rule_id;

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;
2283: CLOSE csr_rules;
2284: