DBA Data[Home] [Help]

APPS.PAY_HK_SOE_PKG dependencies on FND_CURRENCIES

Line 22: return fnd_currencies.currency_code%type is

18: -- Returns the Currency Code for the Business Group.
19: ------------------------------------------------------------------------
20: function business_currency_code
21: (p_business_group_id in hr_organization_units.business_group_id%type)
22: return fnd_currencies.currency_code%type is
23:
24: v_currency_code fnd_currencies.currency_code%type;
25:
26: cursor currency_code

Line 24: v_currency_code fnd_currencies.currency_code%type;

20: function business_currency_code
21: (p_business_group_id in hr_organization_units.business_group_id%type)
22: return fnd_currencies.currency_code%type is
23:
24: v_currency_code fnd_currencies.currency_code%type;
25:
26: cursor currency_code
27: (c_business_group_id hr_organization_units.business_group_id%type) is
28: select fcu.currency_code

Line 31: fnd_currencies fcu

27: (c_business_group_id hr_organization_units.business_group_id%type) is
28: select fcu.currency_code
29: from hr_organization_information hoi,
30: hr_organization_units hou,
31: fnd_currencies fcu
32: where hou.business_group_id = c_business_group_id
33: and hou.organization_id = hoi.organization_id
34: and hoi.org_information_context = 'Business Group Information'
35: and fcu.issuing_territory_code = hoi.org_information9;