INV Organization Hierarchy Exceptions

SELECT  SUBSTR(ORGANIZATION_NAME, 1,50) "Organization Name",
               ORGANIZATION_CODE "Code"
FROM     ORG_ORGANIZATION_DEFINITIONS
WHERE   ORGANIZATION_ID NOT IN 
(SELECT  DISTINCT ORGANIZATION_ID_PARENT 
 FROM     PER_ORG_STRUCTURE_ELEMENTS)
 AND       ORGANIZATION_ID NOT IN 
(SELECT  ORGANIZATION_ID_CHILD 
 FROM    PER_ORG_STRUCTURE_ELEMENTS)
AND   LEGAL_ENTITY = (SELECT ORGANIZATION_ID 	
		     FROM   HR_ALL_ORGANIZATION_UNITS				                                                       WHERE  ltrim(rtrim(NAME)) = :P_LEGAL_ENTITY_NAME)                                
ORDER BY ORGANIZATION_NAME

SELECT SUBSTR(ORGANIZATION_NAME, 1,50) "Organization Name", ORGANIZATION_CODE "Code" FROM ORG_ORGANIZATION_DEFINITIONS WHERE ORGANIZATION_ID NOT IN (SELECT DISTINCT ORGANIZATION_ID_PARENT FROM PER_ORG_STRUCTURE_ELEMENTS) AND ORGANIZATION_ID NOT IN (SELECT ORGANIZATION_ID_CHILD FROM PER_ORG_STRUCTURE_ELEMENTS) AND LEGAL_ENTITY = (SELECT ORGANIZATION_ID FROM HR_ALL_ORGANIZATION_UNITS WHERE ltrim(rtrim(NAME)) = :P_LEGAL_ENTITY_NAME) ORDER BY ORGANIZATION_NAME