APPS.PAY_AU_SOE_PKG dependencies on HR_ORGANIZATION_UNITS

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

143: ------------------------------------------------------------------------
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:

Line 153: (c_business_group_id hr_organization_units.business_group_id%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
155: from hr_organization_information hoi,
156: hr_organization_units hou,
157: fnd_currencies fcu

Line 156: hr_organization_units hou,

152: cursor currency_code
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'

Line 974: hr_organization_units hou,

970: is
971: select hoi.org_information2
972: from
973: hr_organization_information hoi,
974: hr_organization_units hou,
975: pay_personal_payment_methods_f pppm
976: where
977: hoi.org_information_context='AU_SUPER_FUND'
978: and hoi.organization_id=hou.organization_id

Line 1390: (p_business_group_id in hr_organization_units.business_group_id%type,

1386: Inputs : p_business_group_id - Business Group Id
1387: p_payroll_id - Payroll Id
1388: */
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:

Line 1406: Cursor org_currency_code(c_business_group_id hr_organization_units.business_group_id%type) is

1402: and ppf.payroll_id = c_payroll_id
1403: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date
1404: and p_effective_date between popm.effective_start_date and popm.effective_end_date;
1405:
1406: Cursor org_currency_code(c_business_group_id hr_organization_units.business_group_id%type) is
1407: select hoi.org_information10
1408: from hr_organization_information hoi,
1409: hr_organization_units hou
1410: where hou.business_group_id = c_business_group_id

Line 1409: hr_organization_units hou

1405:
1406: Cursor org_currency_code(c_business_group_id hr_organization_units.business_group_id%type) is
1407: select hoi.org_information10
1408: from hr_organization_information hoi,
1409: hr_organization_units hou
1410: where hou.business_group_id = c_business_group_id
1411: and hou.organization_id = hoi.organization_id
1412: and hoi.org_information_context = 'Business Group Information';
1413: