DBA Data[Home] [Help]

APPS.EDW_UTIL dependencies on HR_ORGANIZATION_INFORMATION

Line 14: hr_organization_information hoi,

10: BEGIN
11: SELECT gsob.currency_code
12: INTO l_currency_code
13: FROM hr_all_organization_units hou,
14: hr_organization_information hoi,
15: gl_sets_of_books gsob
16: WHERE hou.organization_id = hoi.organization_id
17: AND ( hoi.org_information_context || '') ='Accounting Information'
18: AND hoi.org_information1 = to_char(gsob.set_of_books_id)

Line 740: HR_ORGANIZATION_INFORMATION HOI,

736: 4,GSOB.SET_OF_BOOKS_ID,
737: 5,GSOB.CHART_OF_ACCOUNTS_ID)
738: FROM
739: HR_all_ORGANIZATION_UNITS HOU,
740: HR_ORGANIZATION_INFORMATION HOI,
741: GL_SETS_OF_BOOKS GSOB,
742: FND_PRODUCT_GROUPS FPG
743: WHERE
744: HOU.ORGANIZATION_ID = HOI.ORGANIZATION_ID