select query

SELECT xxx.payment_id,       (SELECT payment_id
          FROM (SELECT ipa2.payment_id
                  FROM iby_payments_all ipa2
                 WHERE ipa2.payment_id = xxx.payment_id))
  FROM iby_payments_all xxx
 WHERE payment_id = 25006 -- ORA-00904: "XXX"."PAYMENT_ID": invalid identifier 

 


SELECT xxx.payment_id,
       (SELECT payment_id
          FROM (SELECT ipa2.payment_id
                  FROM iby_payments_all ipa2
                 WHERE ipa2.payment_id = 25006))
  FROM iby_payments_all xxx
 WHERE payment_id = 25006   -- Works fine
   
I need the first query working..my actual query is lot more complex..