DBA Data[Home] [Help]

APPS.HR_DE_GENERAL dependencies on FND_CURRENCIES

Line 268: return fnd_currencies.currency_code%type is

264: End get_social_insurance_globals;
265:
266: Function business_group_currency
267: (p_business_group_id in hr_organization_units.business_group_id%type)
268: return fnd_currencies.currency_code%type is
269:
270: v_currency_code fnd_currencies.currency_code%type;
271:
272: cursor currency_code

Line 270: v_currency_code fnd_currencies.currency_code%type;

266: Function business_group_currency
267: (p_business_group_id in hr_organization_units.business_group_id%type)
268: return fnd_currencies.currency_code%type is
269:
270: v_currency_code fnd_currencies.currency_code%type;
271:
272: cursor currency_code
273: (c_business_group_id hr_organization_units.business_group_id%type) is
274: select fcu.currency_code

Line 277: fnd_currencies fcu

273: (c_business_group_id hr_organization_units.business_group_id%type) is
274: select fcu.currency_code
275: from hr_organization_information hoi,
276: hr_organization_units hou,
277: fnd_currencies fcu
278: where hou.business_group_id = c_business_group_id
279: and hou.organization_id = hoi.organization_id
280: and hoi.org_information_context = 'Business Group Information'
281: and fcu.issuing_territory_code = hoi.org_information9;