APPS.FND_MO_REPORTING_API dependencies on HR_ORGANIZATION_INFORMATION

Line 124: FROM hr_organization_information

120: --bug 8649027
121: IF p_reporting_level = '1000' THEN
122: SELECT count(*)
123: INTO l_count
124: FROM hr_organization_information
125: WHERE org_information_context = 'Operating Unit Information'
126: AND TO_NUMBER(trim(org_information3)) = p_reporting_entity_id;
127: END IF;
128:

Line 162: FROM hr_organization_information

158: l_pred := ' AND (NVL(/*ALIAS*/ORG_ID, -99) IN ( -99';
159:
160: FOR l_org_rec IN
161: ( SELECT organization_id
162: FROM hr_organization_information
163: WHERE org_information_context = 'Operating Unit Information'
164: AND DECODE( p_reporting_level
165: , '1000' , TO_NUMBER(trim(org_information3))
166: , '3000' , organization_id ) =

Line 184: FROM hr_organization_information

180: l_pred := ' AND (/*ALIAS*/ORG_ID IS NULL OR INSTRB(''*';
181:
182: FOR l_org_rec IN
183: ( SELECT organization_id
184: FROM hr_organization_information
185: WHERE org_information_context = 'Operating Unit Information'
186: AND DECODE( p_reporting_level
187: , '1000' , TO_NUMBER(trim(org_information3))
188: , '3000' , organization_id ) =

Line 206: || ' FROM hr_organization_information org_info'

202: l_pred :=
203: ' AND (/*ALIAS*/org_id IS NULL OR '
204: ||'EXISTS '
205: ||'( SELECT /*HINT*/ 1'
206: || ' FROM hr_organization_information org_info'
207: || ' WHERE /*ALIAS*/org_id = org_info.organization_id'
208: || ' AND org_info.org_information_context = ''Operating Unit Information''';
209:
210: IF (p_reporting_level = '1000')

Line 234: || ' FROM hr_organization_information'

230: ||'( SELECT -99'
231: || ' FROM DUAL'
232: || ' UNION'
233: || ' SELECT /*HINT*/ organization_id'
234: || ' FROM hr_organization_information'
235: || ' WHERE org_information_context = ''Operating Unit Information''';
236:
237: IF (p_reporting_level = '1000')
238: THEN

Line 444: FROM hr_organization_information

440: , '3000', operating_unit_id) =
441: ( SELECT DECODE( fnd_profile.value_wnps('FND_MO_TOP_REPORTING_LEVEL')
442: , '1000', TO_NUMBER(trim(org_information3))
443: , '3000', organization_id )
444: FROM hr_organization_information
445: WHERE organization_id = fnd_profile.value_wnps('ORG_ID')
446: AND org_information_context = 'Operating Unit Information'
447: )
448: AND entity_id = x_reporting_entity_id;