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 504: FROM hr_organization_information

500: THEN
501:
502: SELECT count(*)
503: INTO l_count
504: FROM hr_organization_information
505: WHERE org_information_context = 'Operating Unit Information'
506: AND DECODE( p_reporting_level
507: , '1000' , TO_NUMBER(org_information3)
508: , '2000' , TO_NUMBER(org_information2)) =

Line 581: || ' FROM hr_organization_information org_info'

577:
578: l_pred := l_pred
579: ||'EXISTS '
580: ||'( SELECT /*HINT*/ 1'
581: || ' FROM hr_organization_information org_info'
582: || ' WHERE /*ALIAS*/org_id = org_info.organization_id'
583: || ' AND org_info.org_information_context = ''Operating Unit Information''';
584:
585: IF (p_reporting_level = '1000')

Line 622: || ' FROM hr_organization_information org_info'

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

Line 661: || ' FROM hr_organization_information org_info'

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

Line 695: || ' FROM hr_organization_information'

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

Line 700: || ' FROM hr_organization_information'

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