APPS.OE_VERSION_HISTORY_UTIL dependencies on OE_PRICE_ADJUSTMENTS

Line 1504: FROM OE_PRICE_ADJUSTMENTS a

1500: l_version_number, --VERSION_NUMBER,
1501: 'N', --AUDIT_FLAG,
1502: l_version_flag, --VERSION_FLAG,
1503: p_phase_change_flag --PHASE_CHANGE_FLAG
1504: FROM OE_PRICE_ADJUSTMENTS a
1505: WHERE a.header_id = p_header_id
1506: AND NOT EXISTS ( SELECT price_adjustment_id
1507: FROM OE_PRICE_ADJS_HISTORY b
1508: WHERE b.price_adjustment_id = a.price_adjustment_id

Line 1647: FROM OE_ORDER_HEADERS_ALL h, OE_PRICE_ADJUSTMENTS p

1643: IF p_price_adjustment_id <> FND_API.G_MISS_NUM THEN
1644:
1645: BEGIN
1646: SELECT h.version_number INTO l_current_version_number
1647: FROM OE_ORDER_HEADERS_ALL h, OE_PRICE_ADJUSTMENTS p
1648: WHERE h.header_id = p.header_id
1649: AND p.price_adjustment_id = p_price_adjustment_id;
1650: EXCEPTION WHEN NO_DATA_FOUND THEN
1651: SELECT h.version_number INTO l_current_version_number