APPS.XLA_MO_REPORTING_API dependencies on HR_ORGANIZATION_INFORMATION

Line 331: FROM hr_organization_information

327: ( SELECT DECODE( fnd_profile.value_wnps('XLA_MO_TOP_REPORTING_LEVEL')
328: , '1000', TO_NUMBER(org_information3)
329: , '2000', TO_NUMBER(org_information2)
330: , '3000', organization_id )
331: FROM hr_organization_information
332: WHERE organization_id = fnd_profile.value_wnps('ORG_ID')
333: AND org_information_context = 'Operating Unit Information'
334: )
335: */

Line 505: SELECT /*+ INDEX(HR_ORGANIZATION_INFORMATION HR_ORGANIZATION_INFORMATIO_FK1) */ count(*)

501:
502: --
503: --8803371 Added hint to force the usage of index
504:
505: SELECT /*+ INDEX(HR_ORGANIZATION_INFORMATION HR_ORGANIZATION_INFORMATIO_FK1) */ count(*)
506: INTO l_count
507: FROM hr_organization_information
508: WHERE org_information_context = 'Operating Unit Information'
509: AND DECODE( p_reporting_level

Line 507: FROM hr_organization_information

503: --8803371 Added hint to force the usage of index
504:
505: SELECT /*+ INDEX(HR_ORGANIZATION_INFORMATION HR_ORGANIZATION_INFORMATIO_FK1) */ count(*)
506: INTO l_count
507: FROM hr_organization_information
508: WHERE org_information_context = 'Operating Unit Information'
509: AND DECODE( p_reporting_level
510: , '1000' , org_information3
511: , '2000' , org_information2) =

Line 584: FROM hr_organization_information

580: END IF;
581:
582: FOR l_org_rec IN
583: (SELECT organization_id
584: FROM hr_organization_information
585: WHERE org_information_context = 'Operating Unit Information'
586: AND DECODE( p_reporting_level
587: , '1000' , org_information3
588: , '2000' , org_information2

Line 624: || ' FROM hr_organization_information org_info'

620:
621: l_pred := l_pred
622: ||'EXISTS '
623: ||'( SELECT /*HINT*/ 1'
624: || ' FROM hr_organization_information org_info'
625: || ' WHERE /*ALIAS*/org_id = org_info.organization_id'
626: || ' AND org_info.org_information_context = ''Operating Unit Information''';
627:
628: IF (p_reporting_level = '1000')

Line 664: || ' FROM hr_organization_information org_info'

660:
661: l_pred := l_pred
662: ||'EXISTS '
663: ||'( SELECT /*HINT*/ 1'
664: || ' FROM hr_organization_information org_info'
665: || ' WHERE /*ALIAS*/org_id = org_info.organization_id'
666: || ' AND org_info.org_information_context = ''Operating Unit Information''';
667:
668: IF (p_reporting_level = '1000')

Line 699: || ' FROM hr_organization_information'

695: ||'( SELECT -99'
696: || ' FROM DUAL'
697: || ' UNION'
698: || ' SELECT /*HINT*/ organization_id'
699: || ' FROM hr_organization_information'
700: || ' WHERE org_information_context = ''Operating Unit Information''';
701: ELSE
702: l_pred := ' AND (/*ALIAS*/org_id IN '
703: ||'( SELECT /*HINT*/ organization_id'

Line 704: || ' FROM hr_organization_information'

700: || ' WHERE org_information_context = ''Operating Unit Information''';
701: ELSE
702: l_pred := ' AND (/*ALIAS*/org_id IN '
703: ||'( SELECT /*HINT*/ organization_id'
704: || ' FROM hr_organization_information'
705: || ' WHERE org_information_context = ''Operating Unit Information''';
706: END IF;
707:
708: IF (p_reporting_level = '1000')