802: BEGIN
803:
804: SELECT le2.name, le1.transacting_entity_flag, le2.transacting_entity_flag
805: INTO le2_name, le1_transacting, le2_transacting
806: FROM XLE_ENTITY_PROFILES le1,
807: XLE_ENTITY_PROFILES le2
808: WHERE le1.legal_entity_id = p_subject_id
809: AND le2.legal_entity_id = p_object_id;
810:
803:
804: SELECT le2.name, le1.transacting_entity_flag, le2.transacting_entity_flag
805: INTO le2_name, le1_transacting, le2_transacting
806: FROM XLE_ENTITY_PROFILES le1,
807: XLE_ENTITY_PROFILES le2
808: WHERE le1.legal_entity_id = p_subject_id
809: AND le2.legal_entity_id = p_object_id;
810:
811: IF (le1_transacting <> 'Y' AND le2_transacting <> 'Y') THEN