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 1356: FROM OE_ORDER_HEADERS

1352: END IF;
1353: --End of bug12616480
1354: SELECT TRANSACTIONAL_CURR_CODE
1355: INTO l_currency_code
1356: FROM OE_ORDER_HEADERS
1357: WHERE HEADER_ID=p_header_id;
1358: ELSIF p_header_id IS NULL AND p_currency_code IS NULL AND p_line_id IS NOT NULL THEN
1359: --Initially g_line_id is null and G_Precision is null and during next calls these values will exists and it returns TRUE
1360: --Start of bug12616480

Line 1367: FROM OE_ORDER_HEADERS OH, OE_ORDER_LINES_ALL OL

1363: END IF;
1364: --End of bug12616480
1365: SELECT /*MOAC_SQL_CHANGES*/ OH.TRANSACTIONAL_CURR_CODE
1366: INTO l_currency_code
1367: FROM OE_ORDER_HEADERS OH, OE_ORDER_LINES_ALL OL
1368: WHERE OH.HEADER_ID=OL.HEADER_ID
1369: AND OL.LINE_ID=p_line_id;
1370: ELSIF p_currency_code IS NOT NULL THEN
1371: l_currency_code:=p_currency_code;