APPS.OE_VERSION_HISTORY_UTIL dependencies on OE_PRICE_ADJUSTMENTS

Line 1441: FROM OE_PRICE_ADJUSTMENTS a

1437: l_version_number, --VERSION_NUMBER,
1438: 'N', --AUDIT_FLAG,
1439: l_version_flag, --VERSION_FLAG,
1440: p_phase_change_flag --PHASE_CHANGE_FLAG
1441: FROM OE_PRICE_ADJUSTMENTS a
1442: WHERE a.header_id = p_header_id
1443: AND NOT EXISTS ( SELECT price_adjustment_id
1444: FROM OE_PRICE_ADJS_HISTORY b
1445: WHERE b.price_adjustment_id = a.price_adjustment_id

Line 1584: FROM OE_ORDER_HEADERS_ALL h, OE_PRICE_ADJUSTMENTS p

1580: IF p_price_adjustment_id <> FND_API.G_MISS_NUM THEN
1581:
1582: BEGIN
1583: SELECT h.version_number INTO l_current_version_number
1584: FROM OE_ORDER_HEADERS_ALL h, OE_PRICE_ADJUSTMENTS p
1585: WHERE h.header_id = p.header_id
1586: AND p.price_adjustment_id = p_price_adjustment_id;
1587: EXCEPTION WHEN NO_DATA_FOUND THEN
1588: SELECT h.version_number INTO l_current_version_number