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 1111: INTO l_currency_code from oe_order_headers

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