APPS.HR_PUMP_GET dependencies on FND_CURRENCIES

Line 2129: /* returns currency_code from fnd_currencies_vl */

2125: end get_element_type_id;
2126:
2127: /** end of NAME additions **/
2128:
2129: /* returns currency_code from fnd_currencies_vl */
2130: function get_currency_code
2131: ( p_name_or_code in varchar2,
2132: p_effective_date in date
2133: ) return varchar2 is

Line 2134: l_code fnd_currencies_vl.currency_code%type;

2130: function get_currency_code
2131: ( p_name_or_code in varchar2,
2132: p_effective_date in date
2133: ) return varchar2 is
2134: l_code fnd_currencies_vl.currency_code%type;
2135: begin
2136: --hr_data_pump.message('**bp** in hr_pump_get.get_cur_code: '|| p_name_or_code);
2137: --
2138: begin

Line 2151: from fnd_currencies_vl

2147: -- Check name
2148: --
2149: select currency_code
2150: into l_code
2151: from fnd_currencies_vl
2152: where name = p_name_or_code
2153: and enabled_flag = 'Y'
2154: and p_effective_date between
2155: nvl(start_date_active, START_OF_TIME) and nvl(end_date_active, END_OF_TIME);

Line 2167: from fnd_currencies -- user underlying table for faster code lookup

2163: -- If the name could not be matched, check if the code was used.
2164: --
2165: select currency_code
2166: into l_code
2167: from fnd_currencies -- user underlying table for faster code lookup
2168: where currency_code = p_name_or_code
2169: and enabled_flag = 'Y'
2170: and p_effective_date between
2171: nvl(start_date_active, START_OF_TIME) and nvl(end_date_active, END_OF_TIME);