APPS.OE_VERSION_COMP dependencies on OE_ORDER_HEADER_HISTORY

Line 372: FROM OE_ORDER_HEADER_HISTORY

368: , x_header_rec.SUPPLIER_SIGNATURE_DATE
369: , x_header_rec.CUSTOMER_SIGNATURE
370: , x_header_rec.CUSTOMER_SIGNATURE_DATE
371: , x_header_rec.CC_INSTRUMENT_ID
372: FROM OE_ORDER_HEADER_HISTORY
373: WHERE HEADER_ID = p_header_id
374: AND VERSION_NUMBER = p_version
375: AND (PHASE_CHANGE_FLAG = p_phase_change_flag
376: OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'

Line 21899: FROM oe_order_header_history

21895: WHERE card_history_change_id = p_instrument_id1;
21896: ELSE
21897: select credit_card_expiration_date
21898: INTO l_attribute_value1
21899: FROM oe_order_header_history
21900: WHERE instrument_id = p_instrument_id1
21901: and rownum=1;
21902: END IF;
21903: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 21953: FROM oe_order_header_history

21949: WHERE card_history_change_id = p_instrument_id2;
21950: ELSE
21951: select credit_card_expiration_date
21952: INTO l_attribute_value2
21953: FROM oe_order_header_history
21954: WHERE instrument_id = p_instrument_id2
21955: and rownum=1;
21956: END IF;
21957: EXCEPTION WHEN NO_DATA_FOUND THEN