APPS.PAY_IE_PAYROLL_ACTIONS_PKG dependencies on FND_CURRENCIES

Line 355: return fnd_currencies.currency_code%type is

351: END fetch_action_id;
352:
353: function business_currency_code
354: (p_business_group_id in hr_organization_units.business_group_id%type)
355: return fnd_currencies.currency_code%type is
356:
357: v_currency_code fnd_currencies.currency_code%type;
358:
359: /* cursor currency_code

Line 357: v_currency_code fnd_currencies.currency_code%type;

353: function business_currency_code
354: (p_business_group_id in hr_organization_units.business_group_id%type)
355: return fnd_currencies.currency_code%type is
356:
357: v_currency_code fnd_currencies.currency_code%type;
358:
359: /* cursor currency_code
360: (c_business_group_id hr_organization_units.business_group_id%type) is
361: select fcu.currency_code

Line 364: fnd_currencies fcu

360: (c_business_group_id hr_organization_units.business_group_id%type) is
361: select fcu.currency_code
362: from hr_organization_information hoi,
363: hr_organization_units hou,
364: fnd_currencies fcu
365: where hou.business_group_id = c_business_group_id
366: and hou.organization_id = hoi.organization_id
367: and hoi.org_information_context = 'Business Group Information'
368: and fcu.issuing_territory_code = hoi.org_information9;

Line 377: fnd_currencies fcu

373: (c_business_group_id hr_organization_units.business_group_id%type) is
374: select /*+ USE_NL(fcu hoi) */
375: fcu.currency_code
376: from hr_organization_information hoi,
377: fnd_currencies fcu
378: where hoi.organization_id = c_business_group_id
379: and hoi.org_information_context = 'Business Group Information'
380: and fcu.issuing_territory_code = hoi.org_information9;
381: