APPS.PO_VAL_HEADERS2 dependencies on FND_CURRENCIES

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

316: RAISE;
317: END type_lookup_code;
318:
319: -------------------------------------------------------------------------
320: -- validate currency_code not null and against FND_CURRENCIES.
321: -------------------------------------------------------------------------
322: PROCEDURE currency_code(
323: p_id_tbl IN po_tbl_number,
324: p_currency_code_tbl IN po_tbl_varchar30,

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

337: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
338: END IF;
339:
340: x_result_type := po_validations.c_result_type_success;
341: -- Bulk validate currency_code not null and against FND_CURRENCIES
342: FORALL i IN 1 .. p_id_tbl.COUNT
343: INSERT INTO po_validation_results_gt
344: (result_set_id,
345: result_type,

Line 373: FROM fnd_currencies cur

369: FROM DUAL
370: WHERE p_currency_code_tbl(i) IS NULL
371: OR NOT EXISTS(
372: SELECT 1
373: FROM fnd_currencies cur
374: WHERE p_currency_code_tbl(i) = cur.currency_code
375: AND cur.enabled_flag = 'Y'
376: AND SYSDATE BETWEEN NVL(cur.start_date_active, SYSDATE - 1)
377: AND NVL(cur.end_date_active, SYSDATE + 1));