SELECT CL.COMPANY_CODE , CL.COUNTRY_CODE , CL.CREATED_BY , CL.CREATED_ON , CL.LIMIT_AMOUNT , CL.UPDATED_BY , CL.UPDATED_ON , CL.AUTHORISED , CL.AUDIT_INDICATOR , CL.UTILISED_AMOUNT FROM XTR_COUNTRY_COMPANY_LIMITS CL WHERE CL.COMPANY_CODE IN (SELECT CA.PARTY_CODE FROM XTR_COMPANY_AUTHORITIES CA , XTR_DEALER_CODES DC WHERE CL.COMPANY_CODE = CA.PARTY_CODE AND CA.DEALER_CODE = DC.DEALER_CODE AND CA.COMPANY_AUTHORISED_FOR_INPUT = 'Y' AND DC.USER_ID = FND_GLOBAL.USER_ID)