DBA Data[Home] [Help]

APPS.PAY_SG_SOE dependencies on HR_ORGANIZATION_UNITS

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

983: ------------------------------------------------------------------------
984: -- Returns the Currency Code for the Business Group.
985: ------------------------------------------------------------------------
986: function business_currency_code
987: (p_business_group_id in hr_organization_units.business_group_id%type)
988: return fnd_currencies.currency_code%type is
989:
990: v_currency_code fnd_currencies.currency_code%type;
991:

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

989:
990: v_currency_code fnd_currencies.currency_code%type;
991:
992: cursor currency_code
993: (c_business_group_id hr_organization_units.business_group_id%type) is
994: select fcu.currency_code
995: from hr_organization_information hoi,
996: hr_organization_units hou,
997: fnd_currencies fcu

Line 996: hr_organization_units hou,

992: cursor currency_code
993: (c_business_group_id hr_organization_units.business_group_id%type) is
994: select fcu.currency_code
995: from hr_organization_information hoi,
996: hr_organization_units hou,
997: fnd_currencies fcu
998: where hou.business_group_id = c_business_group_id
999: and hou.organization_id = hoi.organization_id
1000: and hoi.org_information_context = 'Business Group Information'