DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_UTIL dependencies on FND_CURRENCIES_VL

Line 475: TYPE currency_code_tbl IS TABLE OF fnd_currencies_vl.currency_code%TYPE

471: x_return_status OUT NOCOPY VARCHAR2,
472: x_return_text IN OUT NOCOPY VARCHAR2)
473: IS
474:
475: TYPE currency_code_tbl IS TABLE OF fnd_currencies_vl.currency_code%TYPE
476: INDEX BY BINARY_INTEGER;
477:
478: l_customer_id NUMBER;
479: l_valid_pl VARCHAR2(1);

Line 2040: FROM fnd_currencies_vl

2036: ELSE
2037: BEGIN
2038: SELECT 1
2039: INTO l_count
2040: FROM fnd_currencies_vl
2041: WHERE currency_flag = 'Y'
2042: AND currency_code = p_pb_input_header_rec.currency_code
2043: AND enabled_flag = 'Y'
2044: AND trunc(NVL(start_date_active,

Line 2974: select name into l_currency_name from fnd_currencies_vl where currency_code =

2970: FUNCTION get_currency_name (p_currency_code in varchar2) return varchar2
2971: is
2972: l_currency_name varchar2(240) := null;
2973: begin
2974: select name into l_currency_name from fnd_currencies_vl where currency_code =
2975: p_currency_code;
2976: return l_currency_name;
2977: exception
2978: when no_data_found then return null;