APPS.OE_COMMITMENT_PVT dependencies on OE_ORDER_HEADERS

Line 91: INTO l_currency_code from oe_order_headers

87: oe_debug_pub.add( 'TOTAL COMMITMENT BALANCE:'|| TO_CHAR ( L_TOTAL_BALANCE ) , 1 ) ;
88: END IF;
89: BEGIN
90: SELECT nvl(transactional_curr_code,'USD')
91: INTO l_currency_code from oe_order_headers
92: WHERE header_id=p_header_id;
93: EXCEPTION WHEN no_data_found THEN
94: l_currency_code := 'USD';
95: END ;

Line 393: INTO l_currency_code from oe_order_headers

389: -- build currency format.
390: IF g_fmt_mask IS NULL THEN
391: BEGIN
392: SELECT nvl(transactional_curr_code,'USD')
393: INTO l_currency_code from oe_order_headers
394: WHERE header_id=l_header_id;
395:
396: EXCEPTION
397: WHEN NO_DATA_FOUND THEN

Line 693: FROM oe_order_headers_all

689: , NVL(payment_amount, 0)
690: INTO
691: l_payment_type_code
692: , l_payment_amount
693: FROM oe_order_headers_all
694: WHERE header_id = l_header_id;
695:
696: -- If Credit Card Order then
697: --

Line 1112: INTO l_currency_code from oe_order_headers

1108: -- build currency format.
1109: IF g_fmt_mask IS NULL THEN
1110: BEGIN
1111: SELECT nvl(transactional_curr_code,'USD')
1112: INTO l_currency_code from oe_order_headers
1113: WHERE header_id=p_header_id;
1114:
1115: EXCEPTION
1116: WHEN NO_DATA_FOUND THEN