5730: AND aid.org_id = ai.org_id
5731: AND AID.org_id IN
5732: ( SELECT ASP.org_id
5733: FROM hr_organization_information OI,
5734: --hr_all_organization_units_tl LE, --bug6392886
5735: hr_all_organization_units_tl OU,
5736: ap_system_parameters_all ASP
5737: WHERE ASP.org_id = OI.organization_id
5738: AND OU.organization_id = OI.organization_id
5731: AND AID.org_id IN
5732: ( SELECT ASP.org_id
5733: FROM hr_organization_information OI,
5734: --hr_all_organization_units_tl LE, --bug6392886
5735: hr_all_organization_units_tl OU,
5736: ap_system_parameters_all ASP
5737: WHERE ASP.org_id = OI.organization_id
5738: AND OU.organization_id = OI.organization_id
5739: AND OI.org_information_context = 'Operating Unit Information'
5761: AND aid.org_id = ai.org_id
5762: AND AID.org_id IN
5763: ( SELECT ASP.org_id
5764: FROM hr_organization_information OI,
5765: --hr_all_organization_units_tl LE, --bug6392886
5766: hr_all_organization_units_tl OU,
5767: ap_system_parameters_all ASP
5768: WHERE ASP.org_id = OI.organization_id
5769: AND OU.organization_id = OI.organization_id
5762: AND AID.org_id IN
5763: ( SELECT ASP.org_id
5764: FROM hr_organization_information OI,
5765: --hr_all_organization_units_tl LE, --bug6392886
5766: hr_all_organization_units_tl OU,
5767: ap_system_parameters_all ASP
5768: WHERE ASP.org_id = OI.organization_id
5769: AND OU.organization_id = OI.organization_id
5770: AND OI.org_information_context = 'Operating Unit Information'
5800: and ac.org_id = aph.org_id
5801: AND APH.org_id IN
5802: ( SELECT ASP.org_id
5803: FROM hr_organization_information OI,
5804: --hr_all_organization_units_tl LE, --bug6392886
5805: hr_all_organization_units_tl OU,
5806: ap_system_parameters_all ASP
5807: WHERE ASP.org_id = OI.organization_id
5808: AND OU.organization_id = OI.organization_id
5801: AND APH.org_id IN
5802: ( SELECT ASP.org_id
5803: FROM hr_organization_information OI,
5804: --hr_all_organization_units_tl LE, --bug6392886
5805: hr_all_organization_units_tl OU,
5806: ap_system_parameters_all ASP
5807: WHERE ASP.org_id = OI.organization_id
5808: AND OU.organization_id = OI.organization_id
5809: AND OI.org_information_context = 'Operating Unit Information'
5838: and ac.org_id = aph.org_id
5839: AND APH.org_id IN
5840: ( SELECT ASP.org_id
5841: FROM hr_organization_information OI,
5842: --hr_all_organization_units_tl LE, bug6392886
5843: hr_all_organization_units_tl OU,
5844: ap_system_parameters_all ASP
5845: WHERE ASP.org_id = OI.organization_id
5846: AND OU.organization_id = OI.organization_id
5839: AND APH.org_id IN
5840: ( SELECT ASP.org_id
5841: FROM hr_organization_information OI,
5842: --hr_all_organization_units_tl LE, bug6392886
5843: hr_all_organization_units_tl OU,
5844: ap_system_parameters_all ASP
5845: WHERE ASP.org_id = OI.organization_id
5846: AND OU.organization_id = OI.organization_id
5847: AND OI.org_information_context = 'Operating Unit Information'