6474: AND aid.org_id = ai.org_id
6475: AND AID.org_id IN
6476: ( SELECT ASP.org_id
6477: FROM hr_organization_information OI,
6478: --hr_all_organization_units_tl LE, --bug6392886
6479: hr_all_organization_units_tl OU,
6480: ap_system_parameters_all ASP
6481: WHERE ASP.org_id = OI.organization_id
6482: AND OU.organization_id = OI.organization_id
6475: AND AID.org_id IN
6476: ( SELECT ASP.org_id
6477: FROM hr_organization_information OI,
6478: --hr_all_organization_units_tl LE, --bug6392886
6479: hr_all_organization_units_tl OU,
6480: ap_system_parameters_all ASP
6481: WHERE ASP.org_id = OI.organization_id
6482: AND OU.organization_id = OI.organization_id
6483: AND OI.org_information_context = 'Operating Unit Information'
6505: AND aid.org_id = ai.org_id
6506: AND AID.org_id IN
6507: ( SELECT ASP.org_id
6508: FROM hr_organization_information OI,
6509: --hr_all_organization_units_tl LE, --bug6392886
6510: hr_all_organization_units_tl OU,
6511: ap_system_parameters_all ASP
6512: WHERE ASP.org_id = OI.organization_id
6513: AND OU.organization_id = OI.organization_id
6506: AND AID.org_id IN
6507: ( SELECT ASP.org_id
6508: FROM hr_organization_information OI,
6509: --hr_all_organization_units_tl LE, --bug6392886
6510: hr_all_organization_units_tl OU,
6511: ap_system_parameters_all ASP
6512: WHERE ASP.org_id = OI.organization_id
6513: AND OU.organization_id = OI.organization_id
6514: AND OI.org_information_context = 'Operating Unit Information'
6544: and ac.org_id = aph.org_id
6545: AND APH.org_id IN
6546: ( SELECT ASP.org_id
6547: FROM hr_organization_information OI,
6548: --hr_all_organization_units_tl LE, --bug6392886
6549: hr_all_organization_units_tl OU,
6550: ap_system_parameters_all ASP
6551: WHERE ASP.org_id = OI.organization_id
6552: AND OU.organization_id = OI.organization_id
6545: AND APH.org_id IN
6546: ( SELECT ASP.org_id
6547: FROM hr_organization_information OI,
6548: --hr_all_organization_units_tl LE, --bug6392886
6549: hr_all_organization_units_tl OU,
6550: ap_system_parameters_all ASP
6551: WHERE ASP.org_id = OI.organization_id
6552: AND OU.organization_id = OI.organization_id
6553: AND OI.org_information_context = 'Operating Unit Information'
6582: and ac.org_id = aph.org_id
6583: AND APH.org_id IN
6584: ( SELECT ASP.org_id
6585: FROM hr_organization_information OI,
6586: --hr_all_organization_units_tl LE, bug6392886
6587: hr_all_organization_units_tl OU,
6588: ap_system_parameters_all ASP
6589: WHERE ASP.org_id = OI.organization_id
6590: AND OU.organization_id = OI.organization_id
6583: AND APH.org_id IN
6584: ( SELECT ASP.org_id
6585: FROM hr_organization_information OI,
6586: --hr_all_organization_units_tl LE, bug6392886
6587: hr_all_organization_units_tl OU,
6588: ap_system_parameters_all ASP
6589: WHERE ASP.org_id = OI.organization_id
6590: AND OU.organization_id = OI.organization_id
6591: AND OI.org_information_context = 'Operating Unit Information'