APPS.PAY_IE_PAYROLL_ACTIONS_PKG dependencies on FND_CURRENCIES

Line 356: return fnd_currencies.currency_code%type is

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

Line 358: v_currency_code fnd_currencies.currency_code%type;

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

Line 365: fnd_currencies fcu

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

Line 378: fnd_currencies fcu

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