APPS.OE_ORDER_UTIL dependencies on OE_ORDER_HEADERS

Line 60: FROM OE_ORDER_HEADERS

56: )
57: IS
58: CURSOR header IS
59: SELECT header_id
60: FROM OE_ORDER_HEADERS
61: WHERE HEADER_ID = p_header_id
62: FOR UPDATE NOWAIT;
63: CURSOR lines IS
64: SELECT line_id

Line 1350: FROM OE_ORDER_HEADERS

1346:
1347: IF p_currency_code IS NULL AND p_header_id IS NOT NULL THEN
1348: SELECT TRANSACTIONAL_CURR_CODE
1349: INTO l_currency_code
1350: FROM OE_ORDER_HEADERS
1351: WHERE HEADER_ID=p_header_id;
1352: ELSIF p_header_id IS NULL AND p_currency_code IS NULL AND p_line_id IS NOT NULL THEN
1353: SELECT /*MOAC_SQL_CHANGES*/ OH.TRANSACTIONAL_CURR_CODE
1354: INTO l_currency_code

Line 1355: FROM OE_ORDER_HEADERS OH, OE_ORDER_LINES_ALL OL

1351: WHERE HEADER_ID=p_header_id;
1352: ELSIF p_header_id IS NULL AND p_currency_code IS NULL AND p_line_id IS NOT NULL THEN
1353: SELECT /*MOAC_SQL_CHANGES*/ OH.TRANSACTIONAL_CURR_CODE
1354: INTO l_currency_code
1355: FROM OE_ORDER_HEADERS OH, OE_ORDER_LINES_ALL OL
1356: WHERE OH.HEADER_ID=OL.HEADER_ID
1357: AND OL.LINE_ID=p_line_id;
1358: ELSIF p_currency_code IS NOT NULL THEN
1359: l_currency_code:=p_currency_code;