APPS.OE_ORDER_CLOSE_UTIL dependencies on OE_PRICE_ADJ_ASSOCS

Line 42: AND not exists( select 1 from oe_price_adj_assocs

38: AND list_line_type_code<>'TAX'
39: AND automatic_flag = 'N'
40: AND applied_flag = 'N'
41: AND retrobill_request_id IS NULL --bug4099565
42: AND not exists( select 1 from oe_price_adj_assocs
43: where rltd_price_adj_id = adj.price_adjustment_id);
44:
45: --
46: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 61: DELETE FROM oe_price_adj_assocs

57: BEGIN
58: FETCH c_adjustment_header INTO l_adjustment_id;
59: EXIT WHEN c_adjustment_header%NOTFOUND;
60: --
61: DELETE FROM oe_price_adj_assocs
62: WHERE price_adjustment_id = l_adjustment_id;
63: --
64: DELETE FROM oe_price_adj_attribs
65: WHERE price_adjustment_id = l_adjustment_id;

Line 87: DELETE FROM oe_price_adj_assocs

83: BEGIN
84: FETCH c_adjustment_line INTO l_adjustment_id;
85: EXIT WHEN c_adjustment_line%NOTFOUND;
86: --
87: DELETE FROM oe_price_adj_assocs
88: WHERE price_adjustment_id = l_adjustment_id;
89: --
90: DELETE FROM oe_price_adj_attribs
91: WHERE price_adjustment_id = l_adjustment_id;