Question d’entretien chez American Express

When does one use stored procedure vs Dynamic SQL while working with RDBMS?