DBA Data[Home] [Help]

APPS.PAY_HK_SOE_PKG dependencies on HR_ORGANIZATION_UNITS

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

17: ------------------------------------------------------------------------
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:

Line 27: (c_business_group_id hr_organization_units.business_group_id%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
29: from hr_organization_information hoi,
30: hr_organization_units hou,
31: fnd_currencies fcu

Line 30: hr_organization_units hou,

26: cursor currency_code
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'