DBA Data[Home] [Help]

APPS.PAY_NZ_SOE_PKG dependencies on HR_ORGANIZATION_UNITS

Line 264: (p_business_group_id in hr_organization_units.business_group_id%type)

260: ------------------------------------------------------------------------
261: -- Returns the Currency Code for the Business Group.
262: ------------------------------------------------------------------------
263: function business_currency_code
264: (p_business_group_id in hr_organization_units.business_group_id%type)
265: return fnd_currencies.currency_code%type is
266:
267: v_currency_code fnd_currencies.currency_code%type;
268:

Line 270: (c_business_group_id hr_organization_units.business_group_id%type) is

266:
267: v_currency_code fnd_currencies.currency_code%type;
268:
269: cursor currency_code
270: (c_business_group_id hr_organization_units.business_group_id%type) is
271: select fcu.currency_code
272: from hr_organization_information hoi,
273: hr_organization_units hou,
274: fnd_currencies fcu

Line 273: hr_organization_units hou,

269: cursor currency_code
270: (c_business_group_id hr_organization_units.business_group_id%type) is
271: select fcu.currency_code
272: from hr_organization_information hoi,
273: hr_organization_units hou,
274: fnd_currencies fcu
275: where hou.business_group_id = c_business_group_id
276: and hou.organization_id = hoi.organization_id
277: and hoi.org_information_context = 'Business Group Information'