APPS.PAY_AU_SOE_PKG dependencies on FND_CURRENCIES

Line 148: return fnd_currencies.currency_code%type is

144: -- Returns the Currency Code for the Business Group.
145: ------------------------------------------------------------------------
146: function business_currency_code
147: (p_business_group_id in hr_organization_units.business_group_id%type)
148: return fnd_currencies.currency_code%type is
149:
150: v_currency_code fnd_currencies.currency_code%type;
151:
152: cursor currency_code

Line 150: v_currency_code fnd_currencies.currency_code%type;

146: function business_currency_code
147: (p_business_group_id in hr_organization_units.business_group_id%type)
148: return fnd_currencies.currency_code%type is
149:
150: v_currency_code fnd_currencies.currency_code%type;
151:
152: cursor currency_code
153: (c_business_group_id hr_organization_units.business_group_id%type) is
154: select fcu.currency_code

Line 157: fnd_currencies fcu

153: (c_business_group_id hr_organization_units.business_group_id%type) is
154: select fcu.currency_code
155: from hr_organization_information hoi,
156: hr_organization_units hou,
157: fnd_currencies fcu
158: where hou.business_group_id = c_business_group_id
159: and hou.organization_id = hoi.organization_id
160: and hoi.org_information_context = 'Business Group Information'
161: and fcu.issuing_territory_code = hoi.org_information9;

Line 1393: return fnd_currencies.currency_code%type is

1389: FUNCTION get_currency_code
1390: (p_business_group_id in hr_organization_units.business_group_id%type,
1391: p_payroll_id in pay_payrolls_f.payroll_id%type,
1392: p_effective_date in date)
1393: return fnd_currencies.currency_code%type is
1394:
1395: lv_currency_code fnd_currencies.currency_code%type;
1396:
1397: Cursor payroll_currency_code(c_payroll_id pay_payrolls_f.payroll_id%type) is

Line 1395: lv_currency_code fnd_currencies.currency_code%type;

1391: p_payroll_id in pay_payrolls_f.payroll_id%type,
1392: p_effective_date in date)
1393: return fnd_currencies.currency_code%type is
1394:
1395: lv_currency_code fnd_currencies.currency_code%type;
1396:
1397: Cursor payroll_currency_code(c_payroll_id pay_payrolls_f.payroll_id%type) is
1398: select popm.currency_code
1399: from pay_payrolls_f ppf,