DBA Data[Home] [Help]

APPS.HR_DE_GENERAL dependencies on HR_ORGANIZATION_INFORMATION

Line 275: from hr_organization_information hoi,

271:
272: cursor currency_code
273: (c_business_group_id hr_organization_units.business_group_id%type) is
274: select fcu.currency_code
275: from hr_organization_information hoi,
276: hr_organization_units hou,
277: fnd_currencies fcu
278: where hou.business_group_id = c_business_group_id
279: and hou.organization_id = hoi.organization_id

Line 310: from hr_organization_information tax_info ,

306: select tax_info.org_information1,
307: org.name
308: into tax_office_number,
309: tax_office_name
310: from hr_organization_information tax_info ,
311: hr_organization_units org
312: where tax_info.organization_id = org.organization_id
313: and tax_info.organization_id = p_organization_id
314: and TAX_INFO.org_information_context = 'DE_TAX_OFFICE_INFO';