APPS.PAY_SG_SOE dependencies on FND_CURRENCIES

Line 988: return fnd_currencies.currency_code%type is

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:
992: cursor currency_code

Line 990: v_currency_code fnd_currencies.currency_code%type;

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:
992: cursor currency_code
993: (c_business_group_id hr_organization_units.business_group_id%type) is
994: select fcu.currency_code

Line 997: fnd_currencies fcu

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'
1001: and fcu.issuing_territory_code = hoi.org_information9;

Line 1017: return fnd_currencies.currency_code%type is

1013: ------------------------------------------------------------------------
1014: function get_payroll_currency_code
1015: (p_payroll_id in pay_payrolls_f.payroll_id%type,
1016: p_effective_date in pay_payroll_actions.effective_date%type)
1017: return fnd_currencies.currency_code%type is
1018:
1019: v_currency_code fnd_currencies.currency_code%type;
1020:
1021: cursor csr_currency_code

Line 1019: v_currency_code fnd_currencies.currency_code%type;

1015: (p_payroll_id in pay_payrolls_f.payroll_id%type,
1016: p_effective_date in pay_payroll_actions.effective_date%type)
1017: return fnd_currencies.currency_code%type is
1018:
1019: v_currency_code fnd_currencies.currency_code%type;
1020:
1021: cursor csr_currency_code
1022: (c_payroll_id pay_assignment_actions.assignment_action_id%type,
1023: c_effective_date in pay_payroll_actions.effective_date%type) is

Line 1049: return fnd_currencies.currency_code%type is

1045: ------------------------------------------------------------------------
1046: function get_assignment_currency_code
1047: (p_assignment_id in per_all_assignments_f.assignment_id%type,
1048: p_effective_date in pay_payroll_actions.effective_date%type)
1049: return fnd_currencies.currency_code%type is
1050:
1051: v_currency_code fnd_currencies.currency_code%type;
1052: v_payroll_id pay_payrolls_f.payroll_id%type;
1053:

Line 1051: v_currency_code fnd_currencies.currency_code%type;

1047: (p_assignment_id in per_all_assignments_f.assignment_id%type,
1048: p_effective_date in pay_payroll_actions.effective_date%type)
1049: return fnd_currencies.currency_code%type is
1050:
1051: v_currency_code fnd_currencies.currency_code%type;
1052: v_payroll_id pay_payrolls_f.payroll_id%type;
1053:
1054: cursor csr_get_payroll_id
1055: (c_assignment_id pay_assignment_actions.assignment_action_id%type,