APPS.PO_VAL_HEADERS2 dependencies on FND_CURRENCIES

Line 327: -- validate currency_code not null and against FND_CURRENCIES.

323: RAISE;
324: END type_lookup_code;
325:
326: -------------------------------------------------------------------------
327: -- validate currency_code not null and against FND_CURRENCIES.
328: -------------------------------------------------------------------------
329: PROCEDURE currency_code(
330: p_id_tbl IN po_tbl_number,
331: p_currency_code_tbl IN po_tbl_varchar30,

Line 348: -- Bulk validate currency_code not null and against FND_CURRENCIES

344: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
345: END IF;
346:
347: x_result_type := po_validations.c_result_type_success;
348: -- Bulk validate currency_code not null and against FND_CURRENCIES
349: FORALL i IN 1 .. p_id_tbl.COUNT
350: INSERT INTO po_validation_results_gt
351: (result_set_id,
352: result_type,

Line 380: FROM fnd_currencies cur

376: FROM DUAL
377: WHERE p_currency_code_tbl(i) IS NULL
378: OR NOT EXISTS(
379: SELECT 1
380: FROM fnd_currencies cur
381: WHERE p_currency_code_tbl(i) = cur.currency_code
382: AND cur.enabled_flag = 'Y'
383: AND SYSDATE BETWEEN NVL(cur.start_date_active, SYSDATE - 1)
384: AND NVL(cur.end_date_active, SYSDATE + 1));