APPS.OKC_CURRENCY_API dependencies on HR_ORGANIZATION_INFORMATION

Line 42: from HR_ORGANIZATION_INFORMATION OI2,

38: ***/
39:
40: select gl.currency_code
41: into l_curr_code
42: from HR_ORGANIZATION_INFORMATION OI2,
43: HR_ORGANIZATION_INFORMATION OI1,
44: HR_ALL_ORGANIZATION_UNITS OU,
45: GL_SETS_OF_BOOKS gl
46: where oi1.organization_id = ou.organization_id

Line 43: HR_ORGANIZATION_INFORMATION OI1,

39:
40: select gl.currency_code
41: into l_curr_code
42: from HR_ORGANIZATION_INFORMATION OI2,
43: HR_ORGANIZATION_INFORMATION OI1,
44: HR_ALL_ORGANIZATION_UNITS OU,
45: GL_SETS_OF_BOOKS gl
46: where oi1.organization_id = ou.organization_id
47: and oi2.organization_id = ou.organization_id

Line 121: from HR_ORGANIZATION_INFORMATION OI2,

117: *******/
118:
119: select oi2.ORG_INFORMATION3
120: into l_sob_id
121: from HR_ORGANIZATION_INFORMATION OI2,
122: HR_ORGANIZATION_INFORMATION OI1,
123: HR_ALL_ORGANIZATION_UNITS OU
124: where oi1.organization_id = ou.organization_id
125: and oi2.organization_id = ou.organization_id

Line 122: HR_ORGANIZATION_INFORMATION OI1,

118:
119: select oi2.ORG_INFORMATION3
120: into l_sob_id
121: from HR_ORGANIZATION_INFORMATION OI2,
122: HR_ORGANIZATION_INFORMATION OI1,
123: HR_ALL_ORGANIZATION_UNITS OU
124: where oi1.organization_id = ou.organization_id
125: and oi2.organization_id = ou.organization_id
126: and oi1.org_information_context = 'CLASS'

Line 175: from HR_ORGANIZATION_INFORMATION OI2,

171: ****/
172:
173: select gl.name
174: into l_sob_name
175: from HR_ORGANIZATION_INFORMATION OI2,
176: HR_ORGANIZATION_INFORMATION OI1,
177: HR_ALL_ORGANIZATION_UNITS OU,
178: GL_SETS_OF_BOOKS gl
179: where oi1.organization_id = ou.organization_id

Line 176: HR_ORGANIZATION_INFORMATION OI1,

172:
173: select gl.name
174: into l_sob_name
175: from HR_ORGANIZATION_INFORMATION OI2,
176: HR_ORGANIZATION_INFORMATION OI1,
177: HR_ALL_ORGANIZATION_UNITS OU,
178: GL_SETS_OF_BOOKS gl
179: where oi1.organization_id = ou.organization_id
180: and oi2.organization_id = ou.organization_id