SELECT [petty_cashes].[effective_date] FROM [account_codes]
INNER JOIN [petty_cashes] ON [petty_cashes].[id] = [account_codes].[petty_cash_id] AND petty_cashes.is_disabled = 0 WHERE
[account_codes].[is_disabled] = 0
AND CONVERT(VARCHAR(7), dateadd(s, petty_cashes.effective_date...